/*
Navicat MySQL Data Transfer

Source Server         : 本地
Source Server Version : 50638
Source Host           : localhost:3306
Source Database       : a_system

Target Server Type    : MYSQL
Target Server Version : 50638
File Encoding         : 65001

Date: 2018-12-26 09:45:35
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `es_admin_user`
-- ----------------------------
DROP TABLE IF EXISTS `es_admin_user`;
CREATE TABLE `es_admin_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '平台管理员id',
  `username` varchar(255) DEFAULT NULL COMMENT '管理员名称',
  `password` varchar(255) DEFAULT NULL COMMENT '管理员密码',
  `department` varchar(255) DEFAULT NULL COMMENT '部门',
  `role_id` int(8) DEFAULT NULL COMMENT '权限id',
  `date_line` bigint(11) DEFAULT NULL COMMENT '创建日期',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `user_state` int(2) DEFAULT NULL COMMENT '是否删除',
  `real_name` varchar(50) DEFAULT NULL COMMENT '管理员真实姓名',
  `face` varchar(255) DEFAULT NULL COMMENT '头像',
  `founder` int(2) DEFAULT NULL COMMENT '是否为超级管理员',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='平台管理员(es_admin_user)';

-- ----------------------------
-- Records of es_admin_user
-- ----------------------------
INSERT INTO `es_admin_user` VALUES ('1', 'admin', 'cea3e8e1659582206e0be32539729e9f', 'admin', '21', '1530083955', '', '0', 'Gavin', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/6127372723AF44AA827917048A0C4632.GIF', '0');
INSERT INTO `es_admin_user` VALUES ('8', 'superadmin', '15cefee6071a38058110c203e3402a3b', '超级管理员', '0', '1537864648', '炒鸡管理员666', '0', '炒鸡管理员', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/test/normal/BC4F2746DFD546419B99C531DB23DBDF.png', '1');

-- ----------------------------
-- Table structure for `es_article`
-- ----------------------------
DROP TABLE IF EXISTS `es_article`;
CREATE TABLE `es_article` (
  `article_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `article_name` varchar(50) DEFAULT NULL COMMENT '文章名称',
  `category_id` int(10) DEFAULT NULL COMMENT '分类id',
  `sort` int(5) DEFAULT NULL COMMENT '文章排序',
  `outside_url` varchar(100) DEFAULT NULL COMMENT '外链url',
  `content` longtext COMMENT '文章内容',
  `show_position` varchar(50) DEFAULT NULL COMMENT '显示位置',
  `create_time` bigint(20) DEFAULT NULL COMMENT '添加时间',
  `modify_time` bigint(20) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`article_id`),
  KEY `ind_article_catid` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8 COMMENT='文章(es_article)';

-- ----------------------------
-- Records of es_article
-- ----------------------------
INSERT INTO `es_article` VALUES ('13', '结算订单', '14', '2', '', '<p>结算内容--s<br/></p>', 'OTHER', '1528426802', '1531962703');
INSERT INTO `es_article` VALUES ('14', '用户注册协议', '492', '1', '', '<h4 style=\"text-align: left;\">商城用户注册协议</h4><p>\n		本协议是您与商城网站（简称&quot;本站&quot;，网址：www.javamall.com.cn）所有者（以下简称为&quot;商城&quot;）之间就商城网站服务等相关事宜所订立的契约，请您仔细阅读本注册协议，您点击&quot;同意并继续&quot;按钮后，本协议即构成对双方有约束力的法律文件。</p><h5>第1条 本站服务条款的确认和接纳</h5><p><strong>1.1</strong>本站的各项电子服务的所有权和运作权归商城所有。用户同意所有注册协议条款并完成注册程序，才能成为本站的正式用户。用户确认：本协议条款是处理双方权利义务的契约，始终有效，法律另有强制性规定或双方另有特别约定的，依其规定。</p><p><strong>1.2</strong>用户点击同意本协议的，即视为用户确认自己具有享受本站服务、下单购物等相应的权利能力和行为能力，能够独立承担法律责任。</p><p><strong>1.3</strong>如果您在18周岁以下，您只能在父母或监护人的监护参与下才能使用本站。</p><p><strong>1.4</strong>商城保留在中华人民共和国大陆地区法施行之法律允许的范围内独自决定拒绝服务、关闭用户账户、清除或编辑内容或取消订单的权利。</p><h5>第2条 本站服务</h5><p><strong>2.1</strong>商城通过互联网依法为用户提供互联网信息等服务，用户在完全同意本协议及本站规定的情况下，方有权使用本站的相关服务。</p><p><strong>2.2</strong>用户必须自行准备如下设备和承担如下开支：（1）上网设备，包括并不限于电脑或者其他上网终端、调制解调器及其他必备的上网装置；（2）上网开支，包括并不限于网络接入费、上网设备租用费、手机流量费等。</p><h5>第3条 用户信息</h5><p><strong>3.1</strong>用户应自行诚信向本站提供注册资料，用户同意其提供的注册资料真实、准确、完整、合法有效，用户注册资料如有变动的，应及时更新其注册资料。如果用户提供的注册资料不合法、不真实、不准确、不详尽的，用户需承担因此引起的相应责任及后果，并且商城保留终止用户使用商城各项服务的权利。</p><p><strong>3.2</strong>用户在本站进行浏览、下单购物等活动时，涉及用户真实姓名/名称、通信地址、联系电话、电子邮箱等隐私信息的，本站将予以严格保密，除非得到用户的授权或法律另有规定，本站不会向外界披露用户隐私信息。</p><p><strong>3.3</strong>用户注册成功后，将产生用户名和密码等账户信息，您可以根据本站规定改变您的密码。用户应谨慎合理的保存、使用其用户名和密码。用户若发现任何非法使用用户账号或存在安全漏洞的情况，请立即通知本站并向公安机关报案。</p><p><strong>3.4</strong><strong>用户同意，商城拥有通过邮件、短信电话等形式，向在本站注册、购物用户、收货人发送订单信息、促销活动等告知信息的权利。</strong></p><p><strong>3.5</strong><strong>用户不得将在本站注册获得的账户借给他人使用，否则用户应承担由此产生的全部责任，并与实际使用人承担连带责任。</strong></p><p><strong>3.6</strong><strong>用户同意，商城有权使用用户的注册信息、用户名、密码等信息，登录进入用户的注册账户，进行证据保全，包括但不限于公证、见证等。</strong></p><h5>第4条 用户依法言行义务</h5><p>本协议依据国家相关法律法规规章制定，用户同意严格遵守以下义务：</p><p><strong>（1）</strong>不得传输或发表：煽动抗拒、破坏宪法和法律、行政法规实施的言论，煽动颠覆国家政权，推翻社会主义制度的言论，煽动分裂国家、破坏国家统一的的言论，煽动民族仇恨、民族歧视、破坏民族团结的言论；</p><p><strong>（2）</strong>从中国大陆向境外传输资料信息时必须符合中国有关法规；</p><p><strong>（3）</strong>不得利用本站从事洗钱、窃取商业秘密、窃取个人信息等违法犯罪活动；</p><p><strong>（4）</strong>不得干扰本站的正常运转，不得侵入本站及国家计算机信息系统；</p><p><strong>（5）</strong>不得传输或发表任何违法犯罪的、骚扰性的、中伤他人的、辱骂性的、恐吓性的、伤害性的、庸俗的，淫秽的、不文明的等信息资料；</p><p><strong>（6）</strong>不得传输或发表损害国家社会公共利益和涉及国家安全的信息资料或言论；</p><p><strong>（7）</strong>不得教唆他人从事本条所禁止的行为；</p><p><strong>（8）</strong>不得利用在本站注册的账户进行牟利性经营活动；</p><p><strong>（9）</strong>不得发布任何侵犯他人著作权、商标权等知识产权或合法权利的内容；</p><p>用户应不时关注并遵守本站不时公布或修改的各类合法规则规定。</p><p><strong>本站保有删除站内各类不符合法律政策或不真实的信息内容而无须通知用户的权利。</strong></p><p><strong>若用户未遵守以上规定的，本站有权作出独立判断并采取暂停或关闭用户帐号等措施。</strong>用户须对自己在网上的言论和行为承担法律责任。</p><h5>第5条 商品信息</h5><p>\n		本站上的商品价格、数量、是否有货等商品信息随时都有可能发生变动，本站不作特别通知。由于网站上商品信息的数量极其庞大，虽然本站会尽最大努力保证您所浏览商品信息的准确性，但由于众所周知的互联网技术因素等客观原因存在，本站网页显示的信息可能会有一定的滞后性或差错，对此情形您知悉并理解；商城欢迎纠错，并会视情况给予纠错者一定的奖励。</p><p>为表述便利，商品和服务简称为&quot;商品&quot;或&quot;货物&quot;。</p><h5>第6条 订单</h5><p><strong>6.1</strong>在您下订单时，请您仔细确认所购商品的名称、价格、数量、型号、规格、尺寸、联系地址、电话、收货人等信息。收货人与用户本人不一致的，收货人的行为和意思表示视为用户的行为和意思表示，用户应对收货人的行为及意思表示的法律后果承担连带责任。</p><p><strong>6.2</strong><strong>除法律另有强制性规定外，双方约定如下：本站上销售方展示的商品和价格等信息仅仅是交易信息的发布，您下单时须填写您希望购买的商品数量、价款及支付方式、收货人、联系方式、收货地址等内容；系统生成的订单信息是计算机信息系统根据您填写的内容自动生成的数据，仅是您向销售方发出的交易诉求；销售方收到您的订单信息后，只有在销售方将您在订单中订购的商品从仓库实际直接向您发出时（\n			以商品出库为标志），方视为您与销售方之间就实际直接向您发出的商品建立了交易关系；如果您在一份订单里订购了多种商品并且销售方只给您发出了部分商品时，您与销售方之间仅就实际直接向您发出的商品建立了交易关系；只有在销售方实际直接向您发出了订单中订购的其他商品时，您和销售方之间就订单中该其他已实际直接向您发出的商品才成立交易关系。您可以随时登录您在本站注册的账户，查询您的订单状态。</strong></p><p><strong>6.3</strong><strong>由于市场变化及各种以合理商业努力难以控制的因素的影响，本站无法保证您提交的订单信息中希望购买的商品都会有货；如您拟购买的商品，发生缺货，您有权取消订单。</strong></p><h5>第7条 配送</h5><p><strong>7.1</strong>销售方将会把商品（货物）送到您所指定的收货地址，所有在本站上列出的送货时间为参考时间，参考时间的计算是根据库存状况、正常的处理过程和送货时间、送货地点的基础上估计得出的。</p><p><strong>7.2</strong>因如下情况造成订单延迟或无法配送等，销售方不承担延迟配送的责任：</p><p><strong>（1）</strong>用户提供的信息错误、地址不详细等原因导致的；</p><p><strong>（2）</strong>货物送达后无人签收，导致无法配送或延迟配送的；</p><p><strong>（3）</strong>情势变更因素导致的；</p><p><strong>（4）</strong>不可抗力因素导致的，例如：自然灾害、交通戒严、突发战争等。</p><h5>第8条 所有权及知识产权条款</h5><p><strong>8.1</strong><strong>用户一旦接受本协议，即表明该用户主动将其在任何时间段在本站发表的任何形式的信息内容（包括但不限于客户评价、客户咨询、各类话题文章等信息内容）的财产性权利等任何可转让的权利，如著作权财产权（包括并不限于：复制权、发行权、出租权、展览权、表演权、放映权、广播权、信息网络传播权、摄制权、改编权、翻译权、汇编权以及应当由著作权人享有的其他可转让权利），全部独家且不可撤销地转让给商城所有，用户同意商城有权就任何主体侵权而单独提起诉讼。</strong></p><p><strong>8.2</strong><strong>本协议已经构成《中华人民共和国著作权法》第二十五条（条文序号依照2011年版著作权法确定）及相关法律规定的著作财产权等权利转让书面协议，其效力及于用户在商城网站上发布的任何受著作权法保护的作品内容，无论该等内容形成于本协议订立前还是本协议订立后。</strong></p><p><strong>8.3</strong><strong>用户同意并已充分了解本协议的条款，承诺不将已发表于本站的信息，以任何形式发布或授权其它主体以任何方式使用（包括但不限于在各类网站、媒体上使用）。</strong></p><p><strong>8.4</strong><strong>商城是本站的制作者,拥有此网站内容及资源的著作权等合法权利,受国家法律保护,有权不时地对本协议及本站的内容进行修改，并在本站张贴，无须另行通知用户。在法律允许的最大限度范围内，商城对本协议及本站内容拥有解释权。</strong></p><p><strong>8.5</strong><strong>除法律另有强制性规定外，未经商城明确的特别书面许可,任何单位或个人不得以任何方式非法地全部或部分复制、转载、引用、链接、抓取或以其他方式使用本站的信息内容，否则，商城有权追究其法律责任。</strong></p><p><strong>8.6</strong>本站所刊登的资料信息（诸如文字、图表、标识、按钮图标、图像、声音文件片段、数字下载、数据编辑和软件），均是商城或其内容提供者的财产，受中国和国际版权法的保护。本站上所有内容的汇编是商城的排他财产，受中国和国际版权法的保护。本站上所有软件都是商城或其关联公司或其软件供应商的财产，受中国和国际版权法的保护。</p><h5>第9条 责任限制及不承诺担保</h5><p><strong>除非另有明确的书面说明,本站及其所包含的或以其它方式通过本站提供给您的全部信息、内容、材料、产品（包括软件）和服务，均是在&quot;按现状&quot;和&quot;按现有&quot;的基础上提供的。</strong></p><p><strong>除非另有明确的书面说明,商城不对本站的运营及其包含在本网站上的信息、内容、材料、产品（包括软件）或服务作任何形式的、明示或默示的声明或担保（根据中华人民共和国法律另有规定的以外）。</strong></p><p><strong>商城不担保本站所包含的或以其它方式通过本站提供给您的全部信息、内容、材料、产品（包括软件）和服务、其服务器或从本站发出的电子信件、信息没有病毒或其他有害成分。</strong></p><p><strong>如因不可抗力或其它本站无法控制的原因使本站销售系统崩溃或无法正常使用导致网上交易无法完成或丢失有关的信息、记录等，商城会合理地尽力协助处理善后事宜。</strong></p><h5>第10条 协议更新及用户关注义务</h5><p>\n	根据国家法律法规变化及网站运营需要，商城有权对本协议条款不时地进行修改，修改后的协议一旦被张贴在本站上即生效，并代替原来的协议。用户可随时登录查阅最新协议；<strong><em>用户有义务不时关注并阅读最新版的协议及网站公告。如用户不同意更新后的协议，可以且应立即停止接受商城网站依据本协议提供的服务；如用户继续使用本网站提供的服务的，即视为同意更新后的协议。商城建议您在使用本站之前阅读本协议及本站的公告。</em></strong>\n	如果本协议中任何一条被视为废止、无效或因任何理由不可执行，该条应视为可分的且并不影响任何其余条款的有效性和可执行性。</p><h5>第11条 法律管辖和适用</h5><p>\n	本协议的订立、执行和解释及争议的解决均应适用在中华人民共和国大陆地区适用之有效法律（但不包括其冲突法规则）。\n	如发生本协议与适用之法律相抵触时，则这些条款将完全按法律规定重新解释，而其它有效条款继续有效。\n	如缔约方就本协议内容或其执行发生任何争议，双方应尽力友好协商解决；协商不成时，任何一方均可向有管辖权的中华人民共和国大陆地区法院提起诉讼。</p><h5>第12条 其他</h5><p><strong>12.1</strong>商城网站所有者是指在政府部门依法许可或备案的商城网站经营主体。</p><p><strong>12.2</strong>商城尊重用户和消费者的合法权利，本协议及本网站上发布的各类规则、声明等其他内容，均是为了更好的、更加便利的为用户和消费者提供服务。本站欢迎用户和社会各界提出意见和建议，商城将虚心接受并适时修改本协议及本站上的各类规则。</p><p><strong>12.3</strong>本协议内容中以黑体、加粗、下划线、斜体等方式显著标识的条款，请用户着重阅读。</p><p><strong>12.4</strong>您点击本协议下方的&quot;同意并继续&quot;按钮即视为您完全接受本协议，在点击之前请您再次确认已知悉并完全理解本协议的全部内容。</p>', 'REGISTRATION_AGREEMENT', '1528426802', '1531973029');
INSERT INTO `es_article` VALUES ('25', '商家入驻协议', '492', '1', null, '<p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:center;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">商城入驻协议</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">甲方：</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black"> </span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">乙方：</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">为了规范平台运营，更好地为消费者服务，甲、乙双方本着平等合作、互惠互利的原则，经友好协商，甲乙双方签署以下入驻协议。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">一、合作内容</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">1</span><span style="font-size:16px;font-family:宋体;color:black">、乙方在甲方自有网络交易平台“xx商城”开设店铺，上架商品，</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">2</span><span style="font-size:16px;font-family:宋体;color:black">、甲方对乙方在“xx商城”所销售的产品、服务提供网络技术服务支持，</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">3</span><span style="font-size:16px;font-family:宋体;color:black">、双方根据有效订单按时结算货款。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">二、甲方权利与义务</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">1</span><span style="font-size:16px;font-family:宋体;color:black">、甲方为乙方提供</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">APP</span><span style="font-size:16px;font-family:宋体;color:black">平台的网络宣传。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">2</span><span style="font-size:16px;font-family:宋体;color:black">、甲方为乙方在消费群体中做相关宣传介绍并进行相关推广，以提升乙方的知名度。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">3</span><span style="font-size:16px;font-family:宋体;color:black">、如乙方商品出现任何问题引起纠纷，甲方有权随时告知解除本合同，并下线乙方商品，甲方不负任何责任。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">4</span><span style="font-size:16px;font-family:宋体;color:black">、乙方一旦注册成功，成为本站的合法用户，将得到一个密码和用户名。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">乙方账户不得以任何方式转让，如因乙方主动泄露或私自转让账户等行为导致损失或者引发纠纷，由乙方负责，甲方不承担责任。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">乙方需要对以其用户名进行的所有活动和事件负全责。乙方若发现任何非法使用用户帐户或存在安全漏洞的情况，请立即通告甲方。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">5</span><span style="font-size:16px;font-family:宋体;color:black">、除甲方存在过错外，乙方对自己账户下所有行为结果负责。（包括但不限于发布信息、服务等）。甲方不对用户所发布信息的删除或储存失败负责。甲方有判定用户的行为是否符合甲方服务条款的要求和精神的保留权利，如果用户违背了服务条款的规定，甲方有中断对其提供网络服务的权利。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">6</span><span style="font-size:16px;font-family:宋体;color:black">、如因不可抗力或其他无法控制的原因使甲方销售系统崩溃或无法正常使用导致网上交易无法完成或丢失有关的信息、记录等，甲方不承担责任。但是甲方会尽可能合理地协助处理善后事宜，并努力使客户免受经济损失。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">三、乙方权利与义务</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">1</span><span style="font-size:16px;font-family:宋体;color:black">、乙方应提供加盖公章的单位资质证明复印件，包括营业执照、税务登记证明、开户银行许可证等相关资质，因乙方资质问题而使本协议无法正常履行的结果由乙方负责。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">2</span><span style="font-size:16px;font-family:宋体;color:black">、乙方应遵循相关法律法规的规定并保证自身具备提供本合同项下商品的资质。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:16px;line-height:24px">　<span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">3</span><span style="font-size:16px;font-family:宋体;color:black">、乙方有义务提供合作期间在甲方</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">APP</span><span style="font-size:16px;font-family:宋体;color:black">营销活动和品牌形象展示所需要的所有文字、图片和视频等资料，以供甲方方创作，乙方保证对其提供的该等资料具有完全权利，并有权授权给甲方基于本协议目的进行使用。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">4</span><span style="font-size:16px;font-family:宋体;color:black">、甲方系统通知乙方下单后，乙方因故不能提供的，乙方应立即电话通知下单的消费者和甲方，并做好合理的安抚和处理。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">5</span><span style="font-size:16px;font-family:宋体;color:black">、乙方应对所售商品、服务负责，由交易行为引发的发货、退换货及质保维修、维权投诉处理等由乙方负责。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">四、合作约定</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">1</span><span style="font-size:16px;font-family:宋体;color:black">、双方的品牌归各自所有。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">甲、乙双方均不可在对方未经授权的情况下使用对方名称、</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">LOGO</span><span style="font-size:16px;font-family:宋体;color:black">以及涉及相关内容的销售、促销宣传材料及广告、报纸、杂志、宣传单等。如因此产生的不良后果及损失由违约方自行全部承担。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">2</span><span style="font-size:16px;font-family:宋体;color:black">、任何双方违反本协议所规定的义务导致另一方受到包括但不限于投诉、举报、诉讼或处罚、赔偿等损失，违约方在收到守约方要求纠正其违法行为的书面通知之日，应立即停止其违约行为，并在</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">10</span><span style="font-size:16px;font-family:宋体;color:black">日内赔偿守约方因此受到的损失。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">3</span><span style="font-size:16px;font-family:宋体;color:black">、本协议任何一方均应对其获得对方的业务、经营、财务状况和其他保密资料予以严格保密，不得以任何形式向任何第三方披露。如因任何一方未能履行保密义务而给其他方造</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">成任何损失的，应承担赔偿责任。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">4</span><span style="font-size:16px;font-family:宋体;color:black">、甲方可提供促销、引流、推广等增值服务。乙方如需定制，需支付相应费用，具体须签订补充协议。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">5</span><span style="font-size:16px;font-family:宋体;color:black">、除甲方明示的收费业务外，甲方向乙方提供的服务目前是免费的。如未来向您收取合理费用，甲方会采取合理途径并以足够合理的期限提前通过法定程序通知您，确保您有充分选择的权利。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">五、争议解决</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">1</span><span style="font-size:16px;font-family:宋体;color:black">、未经双方书面同意，各方不得将本协议中的全部或者部分义务转让或委托给第三方。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">2</span><span style="font-size:16px;font-family:宋体;color:black">、甲乙双方任何一方，因不可抗力不能履行合同的，应当及时通知对方，以减轻可能给对方造成的损失。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">3</span><span style="font-size:16px;font-family:宋体;color:black">、甲乙双方任何一方违约的，违约方应向守约方赔偿相应损失。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">4</span><span style="font-size:16px;font-family:宋体;color:black">、由本协议引发的纠纷，双方需协商沟通解决。无法达成一致情形，甲乙双方有权选择以下途径解决：</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">（一）请求消费者协会或者其他依法成立的调解组织调解；</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">（二）向有关行政部门投诉；</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">（三）根据与争议相对方达成的仲裁协议（如有）提请仲裁机构仲裁；</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">（四）向人民法院提起诉讼。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">六、协议生效及其他</span></p><p style="margin-top:5px;text-indent:32px;line-height: 21px;background:white"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">1</span><span style="font-size:16px;font-family:宋体;color:black">、本协议有效期自</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">年</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp; &nbsp;&nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">月</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp; &nbsp;&nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">日起至</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp; &nbsp;&nbsp;&nbsp;</span><span style="font-size: 16px;font-family:宋体;color:black">年</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp; &nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">月</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp; &nbsp;&nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">日止，共</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">年。</span></p><p style="margin-top:5px;text-indent:32px;line-height: 21px;background:white"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;</span></p><p style="margin-top:5px;text-indent:32px;line-height: 21px;background:white"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">2</span><span style="font-size:16px;font-family:宋体;color:black">、协议期满，如双方同意继续合作，应提前</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">1</span><span style="font-size:16px;font-family:宋体;color:black">个月重新签订协议。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">3</span><span style="font-size:16px;font-family:宋体;color:black">、本协议由双方签字或盖章后生效。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">4</span><span style="font-size:16px;font-family:宋体;color:black">、本协议正本一式两份，甲乙双方各执一份。</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:宋体;color:black">　甲方签字（盖章）：</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">乙方签字（盖章）：</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px"><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;</span></p><p style="margin-top:5px;margin-right:0;margin-bottom:5px;margin-left:0;text-align:left;text-indent:32px;line-height:24px">　<span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;&nbsp;&nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">年</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-size: 16px;font-family:宋体;color:black">月</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;&nbsp;&nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">日　</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">年</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp; &nbsp;&nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">月</span><span style="font-size:16px;font-family:&#39;Arial&#39;,sans-serif;color:black">&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="font-size:16px;font-family:宋体;color:black">日</span></p><p>&nbsp;</p><p style="text-align: center; line-height: 150%;"><br/></p>', 'COOPERATION_AGREEMENT', '1528789014', '1528789014');
INSERT INTO `es_article` VALUES ('27', '商城公告2', '14', '1', null, 'test', 'OTHER', '1528789014', '1528789014');
INSERT INTO `es_article` VALUES ('28', '促销1', '479', '1', null, 'test2', 'OTHER', '1528789014', '1528789014');
INSERT INTO `es_article` VALUES ('29', '促销12', '479', '1', null, 'test', 'OTHER', '1528789014', '1528789014');
INSERT INTO `es_article` VALUES ('51', '这是一个商城公告', '14', '0', null, '<p>噢噢噢噢啊啊啊啊啊啊啊阿达阿萨啥</p>', 'OTHER', '1531895181', '1531895181');
INSERT INTO `es_article` VALUES ('56', '我乃是名称，哈哈哈', '14', '0', '', '<p>哈哈哈哈哈哈哈哈哈，这是雪饮刀</p>', 'OTHER', '1531898608', '1532527295');
INSERT INTO `es_article` VALUES ('60', '团购服务协议', '479', '4', null, '<h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">甲乙双方确认并同意本条款中对于各名词的解释及定义，并同意按照该定义履行相关义务</h4><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">1、团购：通过互联网渠道，一定数量的消费者组团，以较低价格购买同一种商品/服务的商业活动。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">2、javashop商城：系提供团购交易服务的网络服务平台。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">3、团购信息：甲方通过javashop商城发布的，在javashop商城网页面上展示的甲方商品/服务信息(如团购价、商品/服务描述、电子券有效期、团购规则等)。该信息为甲方就前述商品/服务向团购用户发出的要约， 一旦团购用户通过javashop商城确认同意购买甲方该商品/服务，即视为甲方与团购用户达成了团购合同。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">4、团购订单：即团购合同，系团购用户通过美团网与甲方间达成的购买商品/服务的合同。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">5、优惠券：指甲方提供给团购用户的商品/服务的消费凭证，团购用户可以凭其获取相应的商品/服务; 优惠券的形式包括但不限于javashop商城页面、短信、电子邮件等。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">6、优惠券消费数：团购用户已实际消费的优惠券数量。因甲方提供的商品/服务需要在javashop商城验证平台上进行验证， 优惠券消费数以javashop商城验证平台上已标记消费的数量为准。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">7、门店价：签订本合同时，甲方提供的商品/服务不参加团购活动时(即在实体经营场所销售/提供时)的单份销售价格。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">8、团购价：甲方提供的商品/服务参加团购活动时的单份销售价格。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">9、代收团购款项：javashop商城实际经营者代甲方收取的团购用户通过javashop商城向甲方支付的已实际消费的优惠券对应的款项。该款项由javashop商城实际经营者代收后转付至乙方，乙方扣除本合同约定的服务费后支付给甲方。计算标准为：团购价乘以优惠券消费数。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">10、服务费：为了实现甲方进入javashop商城开展经营活动、进行团购交易之目的，乙方为甲方提供本合同第二条约定之服务收取的相关费用。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">11、服务费价格：团购用户每实际消费一张优惠券，甲方应向乙方支付的服务费数额。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">12、结算价：针对每一张已实际消费的优惠券，乙方于代收团购款项中扣除应收取的服务费后，应支付给甲方的数额。计算标准为：团购价减服务费价格。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">13、代收净额：对应团购用户实际消费的优惠券数量，乙方应支付给甲方的实际结算款项。计算标准为：结算价乘以优惠券消费数。</p><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; color: rgb(96, 98, 102); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">14、本协议仅为javashop商城团购协议示例，不作为正式协议使用。</p><p><br/></p>', 'OTHER', '1532071185', '1532071185');
INSERT INTO `es_article` VALUES ('66', '团购协议', '492', '0', null, '<p>团购协议</p>', 'GROUP_BUY_AGREEMENT', '1532321372', '1532321372');
INSERT INTO `es_article` VALUES ('67', '平台联系方式', '492', '0', null, '<p>平台联系方式</p>', 'CONTACT_INFORMATION', '1532321900', '1532321900');
INSERT INTO `es_article` VALUES ('98', '关于我们', '454', '1', null, '<p style=\"white-space: normal;\"><span style=\"font-style: italic; font-weight: bold; line-height: 18px;\">关于我们</span></p><p style=\"white-space: normal;\"><span style=\"font-style: italic; font-weight: bold; line-height: 18px;\"><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; color: rgb(102, 102, 102); font-size: 12px; background-color: rgb(255, 255, 255); font-family: 宋体;\"><strong style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 1em;\"><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red;\">修改本区域内容，请到</span><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red; font-family: &quot;Times New Roman&quot;;\">&nbsp;</span><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red;\">管理后台</span><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red; font-family: &quot;Times New Roman&quot;;\">&nbsp;<span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-family: 宋体;\">&gt;&gt;</span>&nbsp;开发管理</span></strong></span><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; color: rgb(102, 102, 102); font-size: 12px; background-color: rgb(255, 255, 255); font-family: 宋体;\"><strong style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 1em;\"><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red; font-family: &quot;Times New Roman&quot;;\"><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px;\">&nbsp;<span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-family: 宋体;\">&gt;&gt; 文章管理</span></span></span><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red;\">&nbsp;&gt;&gt;</span><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red; font-family: &quot;Times New Roman&quot;;\">&nbsp;</span></strong></span><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; color: rgb(102, 102, 102); font-size: 12px; background-color: rgb(255, 255, 255); font-family: 宋体;\"><strong style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 1em;\"><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red;\">文章列表&nbsp;</span></strong></span><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; color: rgb(102, 102, 102); font-size: 12px; background-color: rgb(255, 255, 255); font-family: 宋体;\"><strong style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 1em;\"><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red;\">&gt;&gt;</span><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red; font-family: &quot;Times New Roman&quot;;\">&nbsp; 关于我们&nbsp;&nbsp;</span><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red;\">进行编辑</span></strong></span></span></p><p style=\"white-space: normal;\"><span style=\"font-style: italic; font-weight: bold; line-height: 18px;\"><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; color: rgb(102, 102, 102); font-size: 12px; background-color: rgb(255, 255, 255); font-family: 宋体;\"><strong style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 1em;\"><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red;\"><span style=\"color: rgb(102, 102, 102); font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-size: 12px;\">本商城是新一代专业消费服务网站。我们利用强大的全球化集约采购优势、丰富的电子商务管理服务经验和最先进的互联网技术为您提供最新最好的产品。</span></span></strong></span></span></p><p style=\"white-space: normal;\"><span style=\"font-style: italic; font-weight: bold; line-height: 18px;\"><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; color: rgb(102, 102, 102); font-size: 12px; background-color: rgb(255, 255, 255); font-family: 宋体;\"><strong style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 1em;\"><span style=\"box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; font-size: 14px; color: red;\"></span></strong></span></span><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block; color: rgb(102, 102, 102); background-color: rgb(255, 255, 255);\">成立源起</span></p><p style=\"margin-top: 0px; margin-bottom: 0px; white-space: normal; box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; word-break: break-all;\"><br/></p><p style=\"margin-top: 0px; margin-bottom: 0px; white-space: normal; box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; word-break: break-all;\">在目前广大购物者渐渐对产品性价比要求越来越高的今天，我们发现必须有一套完善的采购经销体系，才能不断的提高产品质量同时降低产品价格，因此减少产品销 售中间环节成本的增加势在必行。因此我们创办中国网上购物商城网站，让产品在网站上直接面对消费者，一方面网站可以提供比在商店购物中更为详尽的资料、历 史渊源以及顾客评论等信息，顾客可以方便的从琳琅满目的各类商品中快速查询出需要的产品；另一方面也大大的减少商店运营成本，将价格实惠转让给顾客。</p><p style=\"margin-top: 0px; margin-bottom: 0px; white-space: normal; box-sizing: inherit; padding: 0px; border: 0px; outline: 0px; word-break: break-all;\"><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block; color: rgb(102, 102, 102); background-color: rgb(255, 255, 255);\">定位</span><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block; color: rgb(102, 102, 102); background-color: rgb(255, 255, 255);\"><span style=\"font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-size: 12px;\">本商城所登陆的商品全部是经过我们在千百种产品中精挑细选出的精品，每一件商品都有自己的特色，每件产品在登陆之前都经过网站编辑的层层筛选，这个将是我们自始至终所坚定的服务原则。</span></span><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block; color: rgb(102, 102, 102); background-color: rgb(255, 255, 255);\"><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: 20px; border: 0px; outline: 0px; display: block;\">承诺</span><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; line-height: 20px; border: 0px; outline: 0px; display: block;\"><span style=\"font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-size: 12px;\">我们承诺提供权威的资讯、最低的价格和便捷的购物方式，为您打造全新的e时代购物新体验！我们承诺严格按照国家法规政策正规经营，经营的产品皆为正规渠道 引进合法缴税的原装正品，有着完善的保修、退货与售后服务制度。为了让您更准确全面的了解您所需要的商品，我们的每一件商品都提供100%实样的高清晰数 码照片、详尽的技术性能指标和制造厂商的介绍。同时采用多种便捷的支付方式和安全快速的配送体系，通过先进的互联网技术进行订单的实时跟踪，并保证每一位 客户资料的安全与保密。</span></span></span></p><p><br/></p>', 'OTHER', '1532762901', '1532762901');
INSERT INTO `es_article` VALUES ('99', '联系我们', '454', '2', null, '<ul style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p><span style=\"box-sizing: inherit;margin: 20px 0px 0px;padding: 0px;font-variant-numeric: normal;font-variant-east-asian: normal;font-stretch: normal;font-size: 18px;line-height: 20px;font-family: &#39;microsoft yahei&#39;;border: 0px;outline: 0px;display: block\">联系我们</span></p></li><li><p>&nbsp;</p></li><li><p><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 12px;font-family: 宋体\"><strong style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 1em\"><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">修改本区域内容，请到</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">&nbsp;</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">商店管理后台</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">&nbsp;<span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;font-family: 宋体\">&gt;&gt;</span>&nbsp;页面设置<span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px\">&nbsp;<span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;font-family: 宋体\">&gt;&gt; 文章管理</span></span></span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">&nbsp;&gt;&gt;</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">&nbsp;</span></strong></span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 12px;font-family: 宋体\"><strong style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 1em\"><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">关于网站 &gt;&gt;</span></strong></span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 12px;font-family: 宋体\"><strong style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 1em\"><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">&nbsp;联系我们&nbsp;&nbsp;</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">进行编辑</span></strong></span></p><p style=\"box-sizing: inherit;margin-top: 0px;margin-bottom: 0px;padding: 0px;border: 0px;outline: 0px\">热心细致的服务态度打造温暖亲切的购物氛围。</p><table class=\"liststyle data\" width=\"100%\"><tbody style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px\"><tr style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px\" class=\"firstRow\"><th style=\"box-sizing: inherit;padding: 0px;text-align: left;border-width: 0px;border-style: initial;border-color: initial;outline: 0px;font-size: 1em;font-weight: normal\">服务热线：</th><td style=\"box-sizing: inherit;padding: 0px;border-width: 0px;border-style: initial;border-color: initial;outline: 0px;font-size: 1em\">010-88888888&nbsp;&nbsp;<span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px\">(工作时间竭诚为您服务)<br/>热线服务时间：<br/>周一～周五 09：00－18：00<br/>周六、周日以及公共假期 12：00－17：00</span></td></tr><tr style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px\"><th style=\"box-sizing: inherit;padding: 0px;text-align: left;border-width: 0px;border-style: initial;border-color: initial;outline: 0px;font-size: 1em;font-weight: normal\">电子邮箱：</th><td style=\"box-sizing: inherit;padding: 0px;border-width: 0px;border-style: initial;border-color: initial;outline: 0px;font-size: 1em\"><a href=\"mailto:storesupport@ourstore.com.cn.net\" style=\"box-sizing: inherit;padding: 0px;color: rgb(51, 51, 51);border: 0px;outline: none;transition-property: color;transition-duration: 0.3s;transition-timing-function: ease\">webmaster@javamall.com</a></td></tr><tr style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px\"><th style=\"box-sizing: inherit;padding: 0px;text-align: left;border-width: 0px;border-style: initial;border-color: initial;outline: 0px;font-size: 1em;font-weight: normal\">商店留言：</th><td style=\"box-sizing: inherit;padding: 0px;border-width: 0px;border-style: initial;border-color: initial;outline: 0px;font-size: 1em\">您可以点击“商店留言”将您的意见和建议提给我们。</td></tr><tr style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px\"><th style=\"box-sizing: inherit;padding: 0px;text-align: left;border-width: 0px;border-style: initial;border-color: initial;outline: 0px;font-size: 1em;font-weight: normal\">地&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 址：</th><td style=\"box-sizing: inherit;padding: 0px;border-width: 0px;border-style: initial;border-color: initial;outline: 0px;font-size: 1em\">北京市朝阳区朝阳大街2001号</td></tr><tr style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px\"><th style=\"box-sizing: inherit;padding: 0px;text-align: left;border-width: 0px;border-style: initial;border-color: initial;outline: 0px;font-size: 1em;font-weight: normal\">邮政编码：</th><td style=\"box-sizing: inherit;padding: 0px;border-width: 0px;border-style: initial;border-color: initial;outline: 0px;font-size: 1em\">100000</td></tr></tbody></table></li></ul><p><br/></p>', 'OTHER', '1532763076', '1532763076');
INSERT INTO `es_article` VALUES ('100', '关于网站', '454', '3', null, '<p><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 12px;font-family: 宋体\"><strong style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 1em\"><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">修改本区域内容，请到</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">&nbsp;</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">商店管理后台</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">&nbsp;<span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;font-family: 宋体\">&gt;&gt;</span></span></strong></span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 12px;font-family: 宋体\"><strong style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 1em\"><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">页面设置<span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px\">&nbsp;<span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;font-family: 宋体\">&gt;&gt; 文章管理</span></span></span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">&nbsp;&gt;&gt;</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">&nbsp;</span></strong></span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 12px;font-family: 宋体\"><strong style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 1em\"><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">关于网站</span></strong></span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 12px;font-family: 宋体\"><strong style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 1em\"><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">&nbsp;&gt;&gt;</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">&nbsp; 业务合作&nbsp;&nbsp;</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">进行编辑</span></strong></span></p><ul style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p><span style=\"box-sizing: inherit;margin: 20px 0px 0px;padding: 0px;font-variant-numeric: normal;font-variant-east-asian: normal;font-stretch: normal;font-size: 18px;line-height: 20px;font-family: &#39;microsoft yahei&#39;;border: 0px;outline: 0px;display: block\">媒体/广告合作</span></p></li><li><p>&nbsp;</p></li><li><p><br/></p></li><ul style=\"list-style-type: circle;\" class=\" list-paddingleft-2\"><li><p>联系人：刘先生</p></li><li><p>联系方式：010-88888888</p></li><li><p>合作范围：媒体互动宣传、内容合作、广告投放、物流、配货、技术合作</p></li></ul><li><p><span style=\"box-sizing: inherit;margin: 20px 0px 0px;padding: 0px;font-variant-numeric: normal;font-variant-east-asian: normal;font-stretch: normal;font-size: 18px;line-height: 20px;font-family: &#39;microsoft yahei&#39;;border: 0px;outline: 0px;display: block\">招商咨询</span></p></li><li><p>&nbsp;</p></li><li><p><br/></p></li><ul style=\"list-style-type: circle;\" class=\" list-paddingleft-2\"><li><p>联系人：刘先生</p></li><li><p>联系方式：010-88888888</p></li><li><p>合作范围：品牌服饰入驻及在线市场推广服务</p></li></ul></ul><p><br/></p>', 'OTHER', '1532763121', '1532763121');
INSERT INTO `es_article` VALUES ('101', '业务合作', '454', '4', null, '<p><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 12px;font-family: 宋体\"><strong style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 1em\"><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">修改本区域内容，请到</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">&nbsp;</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">商店管理后台</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">&nbsp;<span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;font-family: 宋体\">&gt;&gt;</span></span></strong></span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 12px;font-family: 宋体\"><strong style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 1em\"><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">页面设置<span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px\">&nbsp;<span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;font-family: 宋体\">&gt;&gt; 文章管理</span></span></span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">&nbsp;&gt;&gt;</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">&nbsp;</span></strong></span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 12px;font-family: 宋体\"><strong style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 1em\"><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">关于网站</span></strong></span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 12px;font-family: 宋体\"><strong style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 1em\"><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">&nbsp;&gt;&gt;</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red;font-family: &#39;Times New Roman&#39;\">&nbsp; 业务合作&nbsp;&nbsp;</span><span style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px;font-size: 14px;color: red\">进行编辑</span></strong></span></p><ul style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p><span style=\"box-sizing: inherit;margin: 20px 0px 0px;padding: 0px;font-variant-numeric: normal;font-variant-east-asian: normal;font-stretch: normal;font-size: 18px;line-height: 20px;font-family: &#39;microsoft yahei&#39;;border: 0px;outline: 0px;display: block\">媒体/广告合作</span></p></li><li><p>&nbsp;</p></li><li><p><br/></p></li><ul style=\"list-style-type: circle;\" class=\" list-paddingleft-2\"><li><p>联系人：刘先生</p></li><li><p>联系方式：010-88888888</p></li><li><p>合作范围：媒体互动宣传、内容合作、广告投放、物流、配货、技术合作</p></li></ul><li><p><span style=\"box-sizing: inherit;margin: 20px 0px 0px;padding: 0px;font-variant-numeric: normal;font-variant-east-asian: normal;font-stretch: normal;font-size: 18px;line-height: 20px;font-family: &#39;microsoft yahei&#39;;border: 0px;outline: 0px;display: block\">招商咨询</span></p></li><li><p>&nbsp;</p></li><li><p><br/></p></li><ul style=\"list-style-type: circle;\" class=\" list-paddingleft-2\"><li><p>联系人：刘先生</p></li><li><p>联系方式：010-88888888</p></li><li><p>合作范围：品牌服饰入驻及在线市场推广服务</p></li></ul></ul><p><br/></p>', 'OTHER', '1532763201', '1532763201');
INSERT INTO `es_article` VALUES ('102', '网站使用条款', '15', '1', null, '<h2 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-weight: normal; line-height: 1.1; color: rgb(102, 102, 102); font-size: 1em; border: 0px; outline: 0px; white-space: normal;\">网站使用条款</h2><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(102, 102, 102); font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-size: 12px; white-space: normal;\">如果您在本网站访问或购物，您便接受了以下条件。</p><h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; line-height: 1.1; color: rgb(102, 102, 102); font-size: 12px; border: 0px; outline: 0px; white-space: normal;\">版权</h4><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(102, 102, 102); font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-size: 12px; white-space: normal;\">本网站上的所有内容诸如文字、图表、标识、按钮图标、图像、声音文件片段、数字下载、数据编辑和软件都是本网站提供者的财产，受中国和国际版权法的保护。 本网站上所有内容的汇编是本网站的排他财产，受中国和国际版权法的保护。本网站上所使用的所有软件都是本网站或其关联公司或其软件供应商的财产，受中国和 国际版权法的保护。</p><h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; line-height: 1.1; color: rgb(102, 102, 102); font-size: 12px; border: 0px; outline: 0px; white-space: normal;\">许可和网站进入</h4><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(102, 102, 102); font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-size: 12px; white-space: normal;\">本网站授予您有限的许可进入和个人使用本网站，未经本网站的明确书面同意不许下载（除了页面缓存）或修改网站或其任何部分。这一许可不包括对本网站或其内 容的转售或商业利用、任何收集和利用产品目录、说明和价格、任何对本网站或其内容的衍生利用、任何为其他商业利益而下载或拷贝账户信息或使用任何数据采 集、 robots或类似的数据收集和摘录工具。未经本网站的书面许可，严禁对本网站的内容进行系统获取以直接或间接创建或编辑文集、汇编、数据库或人名地址录 （无论是否通过robots、spiders、自动仪器或手工操作）。另外，严禁为任何未经本使用条件明确允许的目的而使用本网站上的内容和材料。 未经本网站明确书面同意，不得以任何商业目的对本网站或其任何部分进行复制、复印、仿造、出售、转售、访问、或以其他方式加以利用。未经本网站明确书面同 意，您不得用设计或运用设计技巧把本网站或其关联公司的商标、标识或其他专有信息（包括图像、文字、网页设计或形式）据为己有。未经本网站明确书面同意， 您不可以meta tags或任何其他“隐藏文本”方式使用本网站的名字和商标。任何未经授权的使用都会终止本网站所授予的允许或许可。您被授予有限的、可撤销的和非独家的 权利建立链接到本网站主页的超链接，只要这个链接不以虚假、误导、贬毁或其他侵犯性方式描写本网站、其关联公司或它们的产品和服务。</p><h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; line-height: 1.1; color: rgb(102, 102, 102); font-size: 12px; border: 0px; outline: 0px; white-space: normal;\">评论、意见、消息和其他内容</h4><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(102, 102, 102); font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-size: 12px; white-space: normal;\">访问者可以张贴评论、意见及其他内容，以及提出建议、主意、意见、问题或其他信息，只要内容不是非法、淫秽、威胁、诽谤、侵犯隐私、侵犯知识产权或以其他 形式对第三者构成伤害或侵犯或令公众讨厌，也不包含软件病毒、政治宣传、商业招揽、连锁信、大宗邮件或任何形式的“垃圾邮件”。您不可以使用虚假的电子邮 件地址、冒充任何他人或实体或以其它方式对卡片或其他内容的来源进行误导。本网站保留清除或编辑这些内容的权利（但非义务），但不对所张贴的内容进行经常 性的审查。如果您确实张贴了内容或提交了材料，除非我们有相反指示，您授予本网站及其关联公司非排他的、免费的、永久的、不可撤销的和完全的再许可权而在 全世界范围内任何媒体上使用、复制、修改、改写、出版、翻译、创作衍生作品、分发和展示这样的内容。您授予本网站及其关联公司和被转许可人使用您所提交的 与这些内容有关的名字的权利，如果他们选择这样做的话。您声明并担保您拥有或以其它方式控制您所张贴内容的权利，内容是准确的，对您所提供内容的使用不违 反本政策并不会对任何人和实体造成伤害。您声明并保证对于因您所提供的内容引起的对本网站或其关联公司损害进行赔偿。本网站有权监控和编辑或清除任何活动 或内容。本网站对您或任何第三方所张贴的内容不承担责任。</p><h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; line-height: 1.1; color: rgb(102, 102, 102); font-size: 12px; border: 0px; outline: 0px; white-space: normal;\">产品说明</h4><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(102, 102, 102); font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-size: 12px; white-space: normal;\">本网站及其关联公司努力使产品说明尽可能准确。不过，由于实际条件限制，本网站并不保证产品说明或本网站上的其他内容是准确的、完整的、可靠的、最新的或无任何错误的。</p><h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; line-height: 1.1; color: rgb(102, 102, 102); font-size: 12px; border: 0px; outline: 0px; white-space: normal;\">电子通讯</h4><p style=\"box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(102, 102, 102); font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-size: 12px; white-space: normal;\">当您访问本网站或给我们发送电子邮件时，您与我们用电子方式进行联系。您同意以电子方式接受我们的信息。我们将用电子邮件或通过在本网站上发布通知的方式 与您进行联系。您同意我们用电子方式提供给您的所有协议、通知、披露和其他信息是符合此类通讯必须是书面形式的法定要求的。如果并且当本网站能够证明以电 子形式的信息已经发送给您或者在本网站张贴这样的通知，将被视为您已收到所有协议、声明、披露和其他信息。</p><p><br/></p>', 'OTHER', '1532763507', '1532763507');
INSERT INTO `es_article` VALUES ('103', '购物流程', '15', '2', null, '<p>简单的购物流程怎样注册？</p><p style="box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(102, 102, 102); font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-size: 12px; white-space: normal; background-color: rgb(255, 255, 255);">答：您可以直接点击&quot;会员注册&quot;进行注册。注册很简单，您只需按注册向导的要求输入一些基本信息即可。为了准确地为您服务，请务必在注册时填写您的真实信息，我们会为您保密。输入的帐号要2-10位，仅可支持汉字、字母、数字、“-”、“_”的组合。</p><p>怎样成为会员?</p><p style="box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(102, 102, 102); font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-size: 12px; white-space: normal; background-color: rgb(255, 255, 255);">答：您可以直接点击&quot;会员登录与注册&quot;进行注册。注册很简单，您只需根据系统提示输入相关资料即可，请您填写完毕时，务必核对填写内容的准确性，并谨记您的会员账号和密码，以便您查询订单或是希望网站提供予您更多的服务时用以核对您的身份。</p><p>如何在网上下单购买，怎么一个操作流程呢？</p><p style="box-sizing: inherit; margin-top: 0px; margin-bottom: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(102, 102, 102); font-family: Arial, Verdana, 宋体, &quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Helvetica, sans-serif; font-size: 12px; white-space: normal; background-color: rgb(255, 255, 255);">答：这种方式和您逛商场的方式十分相似，您只要按照我们的商品分类页面或进入&quot;钻石珠宝&quot;、&quot;个性定制&quot;等逐页按照链接指明的路径浏览就可以了。 一旦看中了您喜欢的商品，您可以随时点击&quot;加入购物车&quot;按钮将它放入&quot;购物车&quot;。随后，您可以按&quot;去结算&quot;。我们的商品十分丰富，不过您别担心，我们在 每一页中都设立了详细明白的导航条，您是不会迷路的。</p><p><br/></p>', 'OTHER', '1532763566', '1532763566');
INSERT INTO `es_article` VALUES ('104', '常见问题', '15', '2', null, '<ul class="help2_right_ul3 list-paddingleft-2" style="list-style-type: none;"><li><p><span style="box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;">1、本商城所售商品都是正品行货吗？售后服务怎样？</span></p></li><li><p>&nbsp;</p></li><li><p>答：本商城所售商品都是正品行货，免费提供发票。凭本商城销售凭证，所有商品都可以享受售后服务保障，本商城将严格针对所售商品履行换货和退货的义务。</p></li><li><p><span style="box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;">2、本商城的价格和实体店的售价为什么相差那么多？</span></p></li><li><p>&nbsp;</p></li><li><p>答：一件商品从生产商到总代理商、大小批发商、到租金昂贵装修豪华的实体店，每个环节层层加价，消费者只能被动接受虚高的价格，而本商城是厂家直供。</p></li><li><p><span style="box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;">3、如何在本商城购买下单？</span></p></li><li><p>&nbsp;</p></li><li><p>答：在本商城下单与大多数购物网站是一样的，如果您对网络购物不太了解可以点击<a href="http://v65.javamall.com.cn/help-17-32.html" style="box-sizing: inherit; margin: 0px; padding: 0px; color: rgb(0, 126, 255); text-decoration-line: none; border: 0px; outline: none; word-break: break-all; transition-property: color; transition-duration: 0.3s; transition-timing-function: ease;">本商城购物流程</a>。</p></li><li><p><span style="box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;">4、运输造成损坏怎么办？</span></p></li><li><p>&nbsp;</p></li><li><p>答：因路上运输造成商品损坏或者丢件由我们承担商品损失，所以您无需担心运输问题。（经过长途运输产品外包装可能会有轻微的碰撞是正常的，但并不会损坏包装盒内的商品，本商城的包装是有名的强壮哦）</p></li><li><p><span style="box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;">5、请问运费是多少？</span></p></li><li><p>&nbsp;</p></li><li><p>答：（1）您可以点击→配送服务→运费说明。<br/>&nbsp;&nbsp;&nbsp; （2）您点击商品购买后，提交订单过程中系统会告知您具体的运费运时。</p></li><li><p><span style="box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;">6、多少时间可以送到？</span></p></li><li><p>&nbsp;</p></li><li><p>答：通常我们仓库都有现货，每天16：30之前的订单当天就可以通过快递发货,普通快递全国范围内除云南、甘肃、海南、西藏、新疆、青海，约1-4天送达，货到付款约3-7天送达（快递上门送货前可能会与您电话联系），您也可以到会员中心&gt;我的订单查询快递情况。</p></li><li><p><span style="box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;">7、我收到商品不满意怎么办？</span></p></li><li><p>&nbsp;</p></li><li><p>答：在您收到商品后的30天之内，如果对商品不满意、不喜欢，且未拆封使用或质量问题的前提下，您可以无条件退货或置换您满意的其它商品。</p></li><li><p><span style="box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;">8、 给不给开发票？</span></p></li><li><p>&nbsp;</p></li><li><p>答：我们销售的所有商品都是免费提供正规发票的，在您下订单时结算时勾选索取发票，填写相关信息，我们会在您收到货后30天（因涉及退换货流程，发票不能随商品一起发出，给您造成不便尽请谅解）以平邮的方式将发票邮寄给您，如需提前索取发票请联系在线客服或拨打客服电话：4001-234-567。</p></li><li><p><span style="box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;">9、本商城都有哪些支付方式？</span></p></li><li><p>&nbsp;</p></li><li><p>答：我们目前支持的付款方式包括网上支付，银行转账和货到付款，详情见：<a href="http://v65.javamall.com.cn/help-19-20.html" style="box-sizing: inherit; margin: 0px; padding: 0px; color: rgb(0, 126, 255); text-decoration-line: none; border: 0px; outline: none; word-break: break-all; transition-property: color; transition-duration: 0.3s; transition-timing-function: ease;">支付方式</a>。</p></li><li><p><span style="box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;">10、退货换货的运费怎么算？</span></p></li><li><p>&nbsp;</p></li><li><p>答：（1）购买商品30天内(商品未拆封使用)，由于顾客自身原因退、换等值或超值的商品时，由顾客承担退回货物至本商城时所需的运费和本商城发送的运费。邮费通过支付宝支付到<span style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(0, 126, 255);">pay@yourdomain.com</span>或者银行转账到我们的银行卡号即可。<br/>&nbsp;&nbsp;&nbsp; （2）购买商品30天内且由于商品的质量问题退换货时，由本商城补贴顾客退回货物的运费（已购物券的形式返还）及本商城承担再次发送的运费。</p></li><li><p><span style="box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;">11、我是在校学生，学校的地址可以货到付款吗？</span></p></li><li><p>&nbsp;</p></li><li><p>答：大学以下等级的学校不支持货到付款服务。但您可以选择款到发货。</p></li></ul><p><br/></p>', 'OTHER', '1532763944', '1532763944');
INSERT INTO `es_article` VALUES ('105', '收货与验货', '449', '1', null, '<ul class=\"help2_right_ul3 list-paddingleft-2\" style=\"list-style-type: none;\"><li><p><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;\">签收商品时需要注意的问题</span></p></li><li><p>&nbsp;</p></li><li><p>1、送货上门、货到付款订单：快递员送货上门时，请您务必当面对照发货单核对商品，如果出现商品数量缺少、商品破损，请您当场办理整单商品的退货。若订单中含有赠品，请一并退回。一旦您确认签字，我们将无法为您办理退换或补发。2、 邮局邮寄订单：请您在领取包裹时务必检查外包装，如果发现包裹破损，请您不要签收，随后请及时将包裹单原件邮寄给我们，您的包裹单原件将作为我们为您办理 补发或退款的唯一证明。收到包裹单后，我们将为您办理相关手续。如您未拆开外包装箱，也可以当场全部退货。平邮订单，在收到包裹时，如发现包裹破损，请您 要求邮局出具包裹破损证明。<span style=\"box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(255, 0, 0);\">注：敬请您在验货签收时仔细核对发票，如果出现发票开错或漏开，请您及时联系我们，注明订单号、邮寄地址和收信人姓名，我们接到您的信息后会尽快为您开具，并邮寄给您。</span></p></li><ol style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p>特别提示：</p></li><li><p>如果您的订单使用帐户余额或礼券支付，只有退货商品的金额小于实际应付款金额时才可办理。</p></li><li><p>如果您的订单中含有赠品，将无法提供此项服务；如果是成套商品，您只能整套退货。如果是捆绑商品，您在退主商品的同时需要将赠品一起退回。</p></li></ol></ul><p><br/></p>', 'OTHER', '1532764016', '1532764016');
INSERT INTO `es_article` VALUES ('106', '配送方式', '449', '2', null, '<p><font color=\"#666666\" face=\"microsoft yahei\"><span style=\"font-size: 18px; background-color: rgb(255, 255, 255);\">关于配送方式</span></font></p><p><font color=\"#666666\" face=\"microsoft yahei\"><span style=\"font-size: 18px; background-color: rgb(255, 255, 255);\"><br/></span></font></p><p><font color=\"#666666\" face=\"Arial, Verdana, 宋体, Lucida Grande, Lucida Sans Unicode, Helvetica, sans-serif\"><span style=\"font-size: 12px; background-color: rgb(255, 255, 255);\">本网站配送方式请咨询商家</span></font></p>', 'OTHER', '1532764093', '1532764093');
INSERT INTO `es_article` VALUES ('108', '在线支付', '450', '2', '', '<ul style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p><br/></p></li><li><p><span style=\"box-sizing: inherit;margin: 20px 0px 0px;padding: 0px;font-variant-numeric: normal;font-variant-east-asian: normal;font-stretch: normal;font-size: 18px;line-height: 20px;font-family: &#39;microsoft yahei&#39;;border: 0px;outline: 0px;display: block\">在线支付</span></p></li><li><p>&nbsp;</p></li><li><p style=\"box-sizing: inherit;margin-top: 0px;margin-bottom: 0px;padding: 0px;border: 0px;outline: 0px\">在线支付支持支付宝、微信支付、中国银联、银联在线。</p></li><li><p style=\"box-sizing: inherit;margin-top: 0px;margin-bottom: 0px;padding: 0px;border: 0px;outline: 0px\">具体已结算页面为准<br/></p></li><table class=\"liststyle data\" width=\"100%\"><tbody style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px\"><tr style=\"box-sizing: inherit;padding: 0px;border: 0px;outline: 0px\" class=\"firstRow\"></tr></tbody></table></ul>', 'OTHER', '1532764244', '1532764356');
INSERT INTO `es_article` VALUES ('109', '货到付款', '450', '2', null, '<ul style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p><span style=\"box-sizing: inherit;margin: 20px 0px 0px;padding: 0px;font-variant-numeric: normal;font-variant-east-asian: normal;font-stretch: normal;font-size: 18px;line-height: 20px;font-family: &#39;microsoft yahei&#39;;border: 0px;outline: 0px;display: block\">货到付款</span></p></li><li><p>&nbsp;</p></li><li><p style=\"box-sizing: inherit;margin-top: 0px;margin-bottom: 0px;padding: 0px;border: 0px;outline: 0px\"><span style=\"font-size: 14px;\">货到付款</span><br/></p></li></ul><p><br/></p>', 'OTHER', '1532764340', '1532764340');
INSERT INTO `es_article` VALUES ('110', '售后服务', '452', '1', null, '<ul class=\"help2_right_ul3 list-paddingleft-2\" style=\"list-style-type: none;\"><li><p><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;\">体贴的售后服务</span></p></li><li><p>&nbsp;</p></li><li><p>本网站所售产品均实行三包政策，请顾客保存好有效凭证，以确保我们为您更好服务。本公司的客户除享受国家规定“三包”。您可以更放心地在这里购物。</p></li><li><p><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;\">保修细则</span></p></li><li><p>&nbsp;</p></li><li><h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: inherit; line-height: 1.1; color: inherit; border: 0px; outline: 0px;\">一、在本网站购买的商品，自购买日起(以到货登记为准)7日内出现性能故障，您可以选择退货、换货或修理。</h4><h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: inherit; line-height: 1.1; color: inherit; border: 0px; outline: 0px;\">二、在本公司购买的商品，自购日起(以到货登记为准)15日内出现性能故障，您可以选择换货或修理。(享受15天退换货无需理由的商品，按《15天退换货无需理由细则》办理)</h4><h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: inherit; line-height: 1.1; color: inherit; border: 0px; outline: 0px;\">三、在本公司购买的商品，自购日起(以到货登记为准)一年之内出现非人为损坏的质量问题，本公司承诺免费保修。</h4></li><ol style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p>在接到您的产品后，我公司将问题商品送厂商特约维修中心检测；</p></li><li><p>检测报出来后，如非人为损坏的，是产品本身质量问题，我公司会及时按您的要求予以退款、换可或维修。</p></li><li><p>如果检测结果是无故障或是人为因素造成的故障，我公司会及时通知您，并咨询您的处理意见。</p></li><li><p>在接到您的产品后，我公司将问题商品送厂商特约维修中心检测；</p></li><li><p>检测报出来后，如非人为损坏的，是产品本身质量问题，我公司会及时按您的要求予以退款、换可或维修。</p></li><li><p>如果检测结果是无故障或是人为因素造成的故障，我公司会及时通知您，并咨询您的处理意见。</p></li><li><p>在接到您的产品后，我公司将问题商品送厂商特约维修中心检测；</p></li><li><p>检测报出来后，如非人为损坏的，是产品本身质量问题，我公司会及时按您的要求予以退款、换可或维修。</p></li><li><p>如果检测结果是无故障或是人为因素造成的故障，我公司会及时通知您，并咨询您的处理意见。</p></li></ol><ol style=\"list-style-type: none;\" class=\" list-paddingleft-2\"></ol><li><p><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;\">收费维修</span></p></li><li><p>&nbsp;</p></li><li><h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: inherit; line-height: 1.1; color: inherit; border: 0px; outline: 0px;\">一、对于人为造成的故障，本公司将采取收费维修，包括：</h4><h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: inherit; line-height: 1.1; color: inherit; border: 0px; outline: 0px;\">二、符合以下条件，可以要求换货：</h4><h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: inherit; line-height: 1.1; color: inherit; border: 0px; outline: 0px;\">三、符合以下条件，可以要求退货：</h4><p>客户收到货物后两天之内，</p></li><ol style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p>发现商品有明显的制造缺陷的</p></li><li><p>货物经过一次换货但仍然存在质量问题的</p></li><li><p>由于人为原因造成超过我们承诺到货之日三天还没收到货物的</p></li><li><p>客户在收到货物时当面在送货员面前拆包检查，发现货物有质量问题的</p></li><li><p>实际收到货物与网站上描述的有很大的出入的</p></li><li><p>换货流程：客户当面要求送货人员退回货物，然后与我们联系。我们会在一个工作日内为您重新发货，货物到达时间顺延。</p></li><li><p>产品内部被私自拆开或其中任何部分被更替；</p></li><li><p>商品里面的条码不清楚，无法成功判断；</p></li><li><p>有入水、碎裂、损毁或有腐蚀等现象；</p></li><li><p>过了保修期的商品。</p></li></ol><ol style=\"list-style-type: none;\" class=\" list-paddingleft-2\"></ol><li><p><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;\">退货流程</span></p></li><li><p>&nbsp;</p></li><li><p>客户在收到货物后两天内与我们联系，我们会在两个工作日内通过银行汇款把您的货款退回。</p><h4 style=\"box-sizing: inherit; margin: 0px; padding: 0px; font-family: inherit; line-height: 1.1; color: inherit; border: 0px; outline: 0px;\">在以下情况我们有权拒绝客户的退换货要求：</h4></li><ol style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p>货物出现破损，但没有在收货时当场要求送货人员换货的</p></li><li><p>超过退换货期限的退换货要求</p></li><li><p>退换货物不全或者外观受损</p></li><li><p>客户发货单据丢失或者不全</p></li><li><p>产品并非我们提供</p></li><li><p>货物本身不存在质量问题的</p></li></ol></ul><p><br/></p>', 'OTHER', '1532764393', '1532764393');
INSERT INTO `es_article` VALUES ('111', '免责条款', '452', '2', null, '<ul class=\"help2_right_ul3 list-paddingleft-2\" style=\"list-style-type: none;\"><li><p><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;\">免责声明</span></p></li><li><p>&nbsp;</p></li><li><p>如因不可抗力或其他无法控制的原因造成网站销售系统崩溃或无法正常使用，从而导致网上交易无法完成或丢失有关的信息、记录等，网站将不承担责任。但是我们将会尽合理的可能协助处理善后事宜，并努力使客户减少可能遭受的经济损失。<br/>本 店可以按买方的要求代办相关运输手续，但我们的责任义务仅限于按时发货，遇到物流（邮政）意外时协助买方查询，不承担任何物流（邮政）提供给顾客之外的赔 偿，一切查询索赔事宜均按照物流（邮政）的规定办理。在物流（邮政）全程查询期限未满之前，买方不得要求赔偿。提醒买方一定核实好收货详细地址和收货人电 话，以免耽误投递。凡在本店购物，均视为如同意此声明。</p></li><li><p><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;\">客户监督</span></p></li><li><p>&nbsp;</p></li><li><p>我们希望通过不懈努力，为客户提供最佳服务，我们在给客户提供服务的全程中接受客户的监督。</p></li><li><p><span style=\"box-sizing: inherit; margin: 20px 0px 0px; padding: 0px; font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 18px; line-height: 20px; font-family: &quot;microsoft yahei&quot;; border: 0px; outline: 0px; display: block;\">争议处理</span></p></li><li><p>&nbsp;</p></li><li><p>如果客户与网站之间发生任何争议，可依据当时双方所认定的协议或相关法律来解决。</p></li></ul><p><br/></p>', 'OTHER', '1532764433', '1532764433');
INSERT INTO `es_article` VALUES ('112', '商品退换货保障', '452', '3', null, '<ul style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p>全商品30天无理由退换货保障:</p></li><li><p>&nbsp;</p></li><li><p>在您收到商品后的30天之内，如果对商品不满意、不喜欢，且未拆封使用或质量问题的前提下，您可以无条件退货或置换您满意的其它商品。 注：退换货日期以客户签收日起算。</p></li><li><p>正品原包，假一赔十！</p></li><li><p>&nbsp;</p></li><li><p>本商城的供应商全部是生产厂商或授权的总代理商或经销商，所售出的商品全部为通过正规进货渠道购进的正牌商品，与您亲临商场选购的商品享受同样的质量保证。本商城对销售产品的质量承担所有相应法律责任，发现假货十倍赔偿！</p></li><li><p>送货上门，货到付款！</p></li><li><p>&nbsp;</p></li><li><p>网上下订单，等商品送到您手上，您可以当场验货。 （本商城目前支持全国1052个城市货到付款，其它边远地区暂不支持。）</p></li><li><p>使您购物满意，是我们最大的希望，我们在努力中，欢迎您给我们提出建议！</p></li></ul><p><br/></p>', 'OTHER', '1532764474', '1532764474');
INSERT INTO `es_article` VALUES ('113', '订单状态', '16', '1', '', '<ul style=\"list-style-type: none;\" class=\" list-paddingleft-2\"><li><p>本商城的订单状态共有10种，下表为详细介绍：</p></li><li><table><tbody><tr class=\"firstRow\"><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\"><span style=\"font-size: 20px;\"><strong>订单状态</strong></span></td><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\"><strong><span style=\"font-size: 20px;\">状态说明</span></strong></td></tr><tr><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">待付款<br/></td><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">成功创建订单，但还未支付</td></tr><tr><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">已付款<br/></td><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">订单成功支付</td></tr><tr><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">待发货<br/></td><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">订单货物已完成配货，正在等待快递发出</td></tr><tr><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">已发货<br/></td><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">订单货物已发出，可以根据物流号在本站或相关物流公司网站查询订单配送状态。</td></tr><tr><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">已收货<br/></td><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">订单商品已经到了下单时选择的收货地址，手动确认收货或者系统自动收货。<br/></td></tr><tr><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">已完成<br/></td><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">已核对并签收订单商品30天（可配置）<br/></td></tr><tr><td valign=\"top\" style=\"word-break: break-all;\">已取消<br/></td><td valign=\"top\" style=\"word-break: break-all;\">表示由您自己或委托客服取消的订单<br/></td></tr><tr><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">已确认（货到付款）<br/></td><td width=\"731\" valign=\"top\" style=\"word-break: break-all;\">货到付款的订单需要本商城人员确认<br/></td></tr></tbody></table></li></ul><p>&nbsp;&nbsp;&nbsp;&nbsp;</p><p><br/></p><p>注意：&nbsp;除支付方式为货到付款的订单,均需要您在下订单后完成支付操作,您的订单才正式生效,本商城才会进行配货发货,由于您付款延迟造成的订单缺货,我们表示抱歉。若您需要修改订单，需要自行取消订单，再重新下订单您已成功提交订单，我们会在工作时间内尽快审核、确认您的订单，如长时间未被确认，请联系本商城客服或拨打客服热线4001-234-567；</p>', 'OTHER', '1532764609', '1565948079');
INSERT INTO `es_article` VALUES ('114', '订单常见问题', '16', '2', null, '<ul style="list-style-type: none;" class=" list-paddingleft-2"><li><p>订单状态说明</p></li><li><p>&nbsp;</p></li><li><p>1、待付款：除支付方式为货到付款的订单,均需要您在下订单后完成支付操作,您的订单才正式生效,本商城才会进行配货发<br/>&nbsp;&nbsp;&nbsp;货,由于您付款延迟造成的订单缺货,我们表示抱歉。（注：若您需要修改订单，需要自行取消订单，再重新下订单）<br/>2、已付款：您已成功提交订单，我们会在工作时间内尽快审核、确认您的订单，如长时间未被确认，请联系商城客服或<br/>&nbsp;&nbsp;&nbsp;拨打客服热线4001-234-567；<br/>3、待发货：表示您的订单已处于配货环节，最晚将在3天内完成这个环节。<br/>4、已发货：表示您的订单货物已发出，您可以根据物流号在本站或相关物流公司网站查询您的订单配送状态。<br/>5、已收货：表示您已收到、核对您所购买的商品并确认签收，此项订单交易成功。<br/>6、已完成：表示您已核对并签收您的商品30天。<br/>7、已取消：表示由您自己或委托客户取消的订单。<br/>8、已确认（货到付款）：货到付款的订单需要本商城人员确认。</p></li><li><p>修改订单</p></li><li><p>&nbsp;</p></li><li><p>1、订单成功提交后，您在未支付前随时可修改或取消您的订单，如果您的订单已完成支付手续，请联络我们的客服人员为您修<br/>&nbsp;&nbsp;&nbsp;改。<br/>2、选择货到付款的客户，在订单状态为已确认之前随时可修改或取消您的订单，如果您的订单已确认请联络我们的客服人员为<br/>&nbsp;&nbsp;&nbsp;您修改。<br/>3、您可以进入&quot;在线客服&quot;向客服人员咨询,客服离线情况下可以给客服留言。或者通过拨打我们的客服热线4001-234-567来修<br/>&nbsp;&nbsp;&nbsp;改您的订单。 &nbsp;</p></li><li><p>Q：如何快速找到我喜欢的商品？<br/><span style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(128, 128, 128);">A：除了通过导航栏的按钮、主页左侧的商品分类来浏览相关商品外，还可通过每页上部侧的搜索框来查找商品。</span><br/><br/>Q: 我不清楚邮编号码怎么办？<br/><span style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(128, 128, 128);">A: 请尽量填写，正确的邮编信息您可以通过拨打当地的邮政11185热线查询 。</span><br/><br/>Q：我的订单选择了款到发货，可以换成货到付款的方式吗？<br/><span style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(128, 128, 128);">A：您只需另下一张货到付款的订单即可。但别忘了取消原来已经下好的款到发货的订单哦!</span><br/><br/>Q：我的订单已经付款，还想修改订单怎么办？<br/><span style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(128, 128, 128);">A：请立即拨打服务热线：4001-234-567，我们的客服会帮助您修改订单。</span><br/><br/>Q: 我没有固定的收货地址怎么办？<br/><span style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(128, 128, 128);">A: 如您可以到离您最近的快递公司去取货也可以下订单，但需电话联系我们的客服。</span><br/><br/>Q：我如何在本商城下订单购买？<br/><span style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(128, 128, 128);">A：在本商城购物非常简单快捷。如果您还不是本商城的会员，可以直接购买或请您先注册成为我们的会员（可享受会员优惠和购<br/>&nbsp;&nbsp;&nbsp;物礼券等优惠活动），如果您已经注册成为我们的会员请您先登录我们网站。然后在您所选择的商品页面选择您所要商品的规<br/>&nbsp;&nbsp;&nbsp;格和数量，然后点击立刻购买按钮即可。然后就是按照你所选择的支付方式操作，本商城的工作人员会在后台看到您的<br/>&nbsp;&nbsp;&nbsp;订单后尽快和您确认，我们在确认收到您的款项后会根据您在购物订单填写的地址和收件人给您配送货物。<br/>&nbsp;&nbsp;&nbsp;如果您还有不明白的地方，请点击</span><a href="http://v65.javamall.com.cn/help-17-32.html" style="box-sizing: inherit; margin: 0px; padding: 0px; color: rgb(0, 0, 0); text-decoration-line: none; border: 0px; outline: none; word-break: break-all; transition-property: color; transition-duration: 0.3s; transition-timing-function: ease;">本商城购买流程</a>。<br/><br/><a style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: none medium; word-break: break-all; transition-property: color; transition-duration: 0.3s; transition-timing-function: ease;">Q:我下了两张订单怎么合并订单？</a><br/><span style="box-sizing: inherit; margin: 0px; padding: 0px; border: 0px; outline: 0px; word-break: break-all; color: rgb(128, 128, 128);">A:1.若两张订单均处于“待审核”状态，请直接删除两张订单后再重新下订单即可。<br/>&nbsp;&nbsp;&nbsp;2.若其中一张订单已被受理，请工作时间联系本商城在线客服或拨打我们的服务热线：4001-234-567 ，我们的客服会帮助您处<br/>&nbsp;&nbsp;&nbsp;理。</span></p></li></ul><p><br/></p>', 'OTHER', '1532764634', '1532764634');

-- ----------------------------
-- Table structure for `es_article_category`
-- ----------------------------
DROP TABLE IF EXISTS `es_article_category`;
CREATE TABLE `es_article_category` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) DEFAULT NULL COMMENT '分类名称',
  `parent_id` int(10) DEFAULT NULL COMMENT '父分类id',
  `path` varchar(50) DEFAULT NULL COMMENT '父子路径0|10|',
  `allow_delete` smallint(1) DEFAULT NULL COMMENT '是否允许删除1允许 0不允许',
  `type` varchar(50) DEFAULT NULL COMMENT '分类类型，枚举值',
  `sort` int(5) DEFAULT NULL COMMENT '排序，正序123',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=493 DEFAULT CHARSET=utf8 COMMENT='文章分类(es_article_category)';

-- ----------------------------
-- Records of es_article_category
-- ----------------------------
INSERT INTO `es_article_category` VALUES ('13', '帮助中心', '0', '0|13|', '0', 'HELP', null);
INSERT INTO `es_article_category` VALUES ('14', '商城公告', '0', '0|14|', '0', 'NOTICE', null);
INSERT INTO `es_article_category` VALUES ('15', '购物指南', '13', '0|13|15|', '1', 'OTHER', '1');
INSERT INTO `es_article_category` VALUES ('16', '订单百事通', '13', '0|13|16|', '1', 'OTHER', '2');
INSERT INTO `es_article_category` VALUES ('449', '配送方式', '13', '0|13|449|', '1', 'OTHER', '3');
INSERT INTO `es_article_category` VALUES ('450', '支付问题', '13', '0|13|450|', '1', 'OTHER', '4');
INSERT INTO `es_article_category` VALUES ('452', '售后问题', '13', '0|13|452|', '1', 'OTHER', '6');
INSERT INTO `es_article_category` VALUES ('454', '关于网站', '13', '0|13|454|', null, 'OTHER', null);
INSERT INTO `es_article_category` VALUES ('479', '商城促销', '0', '0|479|', '1', 'PROMOTION', '0');
INSERT INTO `es_article_category` VALUES ('492', '固定位置', '0', '0|492|', '1', 'POSITION', '0');

-- ----------------------------
-- Table structure for `es_email`
-- ----------------------------
DROP TABLE IF EXISTS `es_email`;
CREATE TABLE `es_email` (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '邮件记录id',
  `title` varchar(255) DEFAULT NULL COMMENT '邮件标题',
  `type` varchar(255) DEFAULT NULL COMMENT '邮件类型',
  `success` int(2) DEFAULT NULL COMMENT '是否成功',
  `email` varchar(255) DEFAULT NULL COMMENT '邮件接收者',
  `content` longtext COMMENT '邮件内容',
  `error_num` int(8) DEFAULT NULL COMMENT '错误次数',
  `last_send` bigint(12) DEFAULT NULL COMMENT '最后发送时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='邮件记录(es_email)';

-- ----------------------------
-- Records of es_email
-- ----------------------------

-- ----------------------------
-- Table structure for `es_express_platform`
-- ----------------------------
DROP TABLE IF EXISTS `es_express_platform`;
CREATE TABLE `es_express_platform` (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '快递平台id',
  `name` varchar(100) DEFAULT NULL COMMENT '快递平台名称',
  `open` int(2) DEFAULT NULL COMMENT '是否开启快递平台,1开启，0未开启',
  `config` longtext COMMENT '快递平台配置',
  `bean` varchar(50) DEFAULT NULL COMMENT '快递平台beanid',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COMMENT='快递平台(es_express_platform)';

-- ----------------------------
-- Records of es_express_platform
-- ----------------------------
INSERT INTO `es_express_platform` VALUES ('36', '快递100', '1', '[{\"name\":\"code\",\"text\":\"公司代码\",\"type\":\"text\",\"value\":\"输入公司代码\"},{\"name\":\"id\",\"text\":\"id\",\"type\":\"text\",\"value\":\"输入应用id\"},{\"name\":\"user\",\"text\":\"用户类型\",\"type\":\"radio\",\"value\":1,\"options\":[{\"label\":\"普通用户\",\"value\":0},{\"label\":\"企业用户\",\"value\":1}]}]', 'kuaidi100Plugin');
INSERT INTO `es_express_platform` VALUES ('37', 'showapi快递', '0', '[{\"name\":\"appid\",\"text\":\"appid\",\"type\":\"text\",\"value\":\"请输入showapi apiid参数\"},{\"name\":\"app_secret\",\"text\":\"密钥\",\"type\":\"text\",\"value\":\"请输入showapi 密钥密钥\"}]', 'showApiPlugin');

-- ----------------------------
-- Table structure for `es_focus_picture`
-- ----------------------------
DROP TABLE IF EXISTS `es_focus_picture`;
CREATE TABLE `es_focus_picture` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `pic_url` varchar(255) DEFAULT NULL COMMENT '图片地址',
  `operation_type` varchar(50) DEFAULT NULL COMMENT '操作类型',
  `operation_param` varchar(255) DEFAULT NULL COMMENT '操作参数',
  `operation_url` varchar(255) DEFAULT NULL COMMENT '操作地址',
  `client_type` varchar(10) DEFAULT NULL COMMENT '客户端类型 pc:pc楼层mobile:移动端楼层',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='焦点图(es_focus_picture)';

-- ----------------------------
-- Records of es_focus_picture
-- ----------------------------
INSERT INTO `es_focus_picture` VALUES ('1', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/05017572.jpg', '1', '', 'http://www.baidu.com', 'mobile');
INSERT INTO `es_focus_picture` VALUES ('2', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/05085057.jpg', '1', '', 'http://www.baidu.com', 'mobile');
INSERT INTO `es_focus_picture` VALUES ('3', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/48319887.jpg', '1', '', 'http://www.baidu.com', 'mobile');
INSERT INTO `es_focus_picture` VALUES ('4', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/48404212.jpg', '1', '', 'http://www.baidu.com', 'mobile');
INSERT INTO `es_focus_picture` VALUES ('9', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/BEC6DE293CEB40769B43984B0C094906.jpg', 'NONE', '', '', 'pc');
INSERT INTO `es_focus_picture` VALUES ('10', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/068EFE2D3E294D55990FA58B1F66A340.jpg', 'NONE', '', '', 'pc');
INSERT INTO `es_focus_picture` VALUES ('11', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/78E53996476C4585B17CDCA9D589DF15.jpg', 'KEYWORD', '周年庆', null, 'WAP');
INSERT INTO `es_focus_picture` VALUES ('12', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/E724A9FA19214C14A025620F1D07F4F3.jpg', 'URL', '/group-buy', null, 'WAP');
INSERT INTO `es_focus_picture` VALUES ('13', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/228DBA21CA9D472F86394A42422277A6.jpg', 'KEYWORD', 'aaaa', null, 'WAP');
INSERT INTO `es_focus_picture` VALUES ('14', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/E0402E75BC0F4B1E82E3189B6E664273.jpg', 'KEYWORD', '鲜果', null, 'WAP');

-- ----------------------------
-- Table structure for `es_hot_keyword`
-- ----------------------------
DROP TABLE IF EXISTS `es_hot_keyword`;
CREATE TABLE `es_hot_keyword` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `hot_name` varchar(50) DEFAULT NULL COMMENT '文字内容',
  `sort` int(5) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='热门关键字(es_hot_keyword)';

-- ----------------------------
-- Records of es_hot_keyword
-- ----------------------------
INSERT INTO `es_hot_keyword` VALUES ('24', '猫粮', '1');
INSERT INTO `es_hot_keyword` VALUES ('25', '狗粮', '2');
INSERT INTO `es_hot_keyword` VALUES ('26', '猪饲料', '3');
INSERT INTO `es_hot_keyword` VALUES ('27', '女装', '4');
INSERT INTO `es_hot_keyword` VALUES ('28', '猪儿虫', '5');

-- ----------------------------
-- Table structure for `es_logi_company`
-- ----------------------------
DROP TABLE IF EXISTS `es_logi_company`;
CREATE TABLE `es_logi_company` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '物流公司id',
  `name` varchar(255) DEFAULT NULL COMMENT '物流公司名称',
  `code` varchar(255) DEFAULT NULL COMMENT '物流公司code',
  `kdcode` varchar(255) DEFAULT NULL COMMENT '快递鸟物流公司code',
  `is_waybill` int(10) DEFAULT NULL COMMENT '是否支持电子面单1：支持 0：不支持',
  `customer_name` varchar(50) DEFAULT NULL COMMENT '物流公司客户号',
  `customer_pwd` varchar(50) DEFAULT NULL COMMENT '物流公司电子面单密码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='物流公司(es_logi_company)';

-- ----------------------------
-- Records of es_logi_company
-- ----------------------------
INSERT INTO `es_logi_company` VALUES ('1', '圆通速递', 'yuantong', 'YTO', '0', '', '');
INSERT INTO `es_logi_company` VALUES ('2', '宅急送', 'zhaijisong', 'ZJS', '0', '', '');
INSERT INTO `es_logi_company` VALUES ('3', '中通速递', 'zhongtong', 'ZTO', '0', '', '');
INSERT INTO `es_logi_company` VALUES ('4', '申通快递', 'shentong', 'STO', '0', '', '');
INSERT INTO `es_logi_company` VALUES ('5', '顺丰速递', 'shunfeng', 'SF', '0', '', '');

-- ----------------------------
-- Table structure for `es_menu`
-- ----------------------------
DROP TABLE IF EXISTS `es_menu`;
CREATE TABLE `es_menu` (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '菜单id',
  `parent_id` int(8) DEFAULT NULL COMMENT '父id',
  `title` varchar(255) DEFAULT NULL COMMENT '菜单标题',
  `url` varchar(255) DEFAULT NULL COMMENT '菜单url',
  `identifier` varchar(255) DEFAULT NULL COMMENT '菜单唯一标识',
  `auth_regular` varchar(255) DEFAULT NULL COMMENT '权限表达式',
  `delete_flag` int(2) DEFAULT NULL COMMENT '删除标记',
  `path` varchar(255) DEFAULT NULL COMMENT '菜单级别标识',
  `grade` int(8) DEFAULT NULL COMMENT '菜单级别',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=229 DEFAULT CHARSET=utf8 COMMENT='菜单表(es_menu)';

-- ----------------------------
-- Records of es_menu
-- ----------------------------
INSERT INTO `es_menu` VALUES ('1', '0', '商品管理', 'xxx', 'goods', '/goods.*', '0', ',1,', '1');
INSERT INTO `es_menu` VALUES ('2', '0', '订单管理', null, 'order', '/order.*', '0', ',2,', '1');
INSERT INTO `es_menu` VALUES ('3', '0', '会员管理', null, 'member', '/member.*', '0', ',3,', '1');
INSERT INTO `es_menu` VALUES ('4', '0', '店铺管理', null, 'shop', '/shop.*', '0', ',4,', '1');
INSERT INTO `es_menu` VALUES ('5', '0', '促销管理', null, 'promotions', '/admin/promotions.*', '0', ',5,', '1');
INSERT INTO `es_menu` VALUES ('6', '0', '页面设置', null, 'page', '/page.*', '0', ',6,', '1');
INSERT INTO `es_menu` VALUES ('7', '0', '统计分析', null, 'statistics', '/statistics.*', '0', ',7,', '1');
INSERT INTO `es_menu` VALUES ('8', '0', '设置管理', null, 'setting', '/system.*', '0', ',8,', '1');
INSERT INTO `es_menu` VALUES ('9', '0', '开发管理', null, 'development', '/development.*', '0', ',9,', '1');
INSERT INTO `es_menu` VALUES ('10', '1', '商品列表', null, 'goodsList', '/admin/goods.*', '0', ',1,10,', '2');
INSERT INTO `es_menu` VALUES ('11', '1', '商品设置', null, 'goodsSetting', '/goodsSetting.*', '0', ',1,11,', '2');
INSERT INTO `es_menu` VALUES ('12', '11', '分类列表', null, 'categoryList', '(/admin/goods/categories.*)|(/admin/goods/parameters.*)|(/admin/goods/parameter-groups.*)', '0', ',1,10,12,', '3');
INSERT INTO `es_menu` VALUES ('13', '11', '品牌列表', null, 'brandList', '/admin/goods/brands.*', '0', ',1,10,13,', '3');
INSERT INTO `es_menu` VALUES ('14', '11', '规格列表', null, 'specList', '/admin/goods/specs.*', '0', ',1,10,14,', '3');
INSERT INTO `es_menu` VALUES ('15', '1', '商品审核', null, 'goodsAudit', '/admin/goods.*', '0', ',1,15,', '2');
INSERT INTO `es_menu` VALUES ('17', '2', '订单列表', null, 'orderList', '(/admin/trade/orders.*)|(/admin/shops.*)', '0', ',2,17,', '2');
INSERT INTO `es_menu` VALUES ('18', '2', '退款单', '', 'refundList', '(/admin/after-sales/refund.*)|(/admin/after-sales/exports.*)', '0', ',2,18,', '2');
INSERT INTO `es_menu` VALUES ('20', '3', '管理会员', null, 'memberManage', '/member.*', '0', ',3,20,', '2');
INSERT INTO `es_menu` VALUES ('21', '20', '会员列表', null, 'memberList', '(/admin/members.*)|(/admin/trade/orders.*)', '0', ',3,20,21,', '3');
INSERT INTO `es_menu` VALUES ('22', '20', '会员回收站', null, 'memberRecycle', '/admin/members.*', '0', ',3,20,22,', '3');
INSERT INTO `es_menu` VALUES ('23', '3', '商品评论', null, 'goodsComment', '/member.*', '0', ',3,23,', '2');
INSERT INTO `es_menu` VALUES ('24', '23', '商品评论列表', null, 'mgoodsCommentList', '/admin/members/comments.*', '0', ',3,23,24,', '3');
INSERT INTO `es_menu` VALUES ('25', '23', '商品咨询列表', null, 'goodsAskList', '/admin/members/asks.*', '0', ',3,23,25,', '3');
INSERT INTO `es_menu` VALUES ('28', '4', '管理店铺', null, 'shopManage', '/shop,*', '0', ',4,28,', '2');
INSERT INTO `es_menu` VALUES ('29', '28', '店铺列表', '', 'shopList', '(/admin/shops.*)|(/admin/goods/categories.*)', '0', ',4,28,29,', '3');
INSERT INTO `es_menu` VALUES ('30', '28', '店铺审核', null, 'shopAudit', '/admin/shops.*', '0', ',4,28,30,', '3');
INSERT INTO `es_menu` VALUES ('33', '4', '店铺模板管理', null, 'shopThemeManage', '/shop.*', '0', ',4,33,', '2');
INSERT INTO `es_menu` VALUES ('34', '33', '模板列表', '', 'themeList', '/admin/shops/themes.*', '0', ',4,33,34,', '3');
INSERT INTO `es_menu` VALUES ('35', '33', 'WAP模板列表', null, 'themeListWap', '/admin/shops/themes.*', '0', ',4,33,35,', '3');
INSERT INTO `es_menu` VALUES ('38', '5', '团购管理', null, 'groupBuyManage', '/promotion.*', '0', ',5,38,', '2');
INSERT INTO `es_menu` VALUES ('39', '38', '团购列表', '', 'groupBuyList', '/admin/promotion.*', '0', ',5,38,39,', '3');
INSERT INTO `es_menu` VALUES ('40', '38', '团购分类', null, 'groupBuyCategory', '/admin/promotion/group-buy-cats.*', '0', ',5,38,40,', '3');
INSERT INTO `es_menu` VALUES ('41', '5', '积分商城', null, 'pointsMallManage', '/promotion.*', '0', ',5,41,', '2');
INSERT INTO `es_menu` VALUES ('42', '41', '积分分类', null, 'pointsClassify', '/admin/promotion/exchange-cats.*', '0', ',5,41,42,', '3');
INSERT INTO `es_menu` VALUES ('43', '41', '积分商品', null, 'pointsGoods', '/admin/goods.*', '0', ',5,41,43,', '3');
INSERT INTO `es_menu` VALUES ('46', '6', 'PC装修', null, 'pcDecoration', '/page.*', '0', ',6,46,', '2');
INSERT INTO `es_menu` VALUES ('48', '46', '楼层装修', '', 'pcFloorManage', '/admin/pages.*', '0', ',6,46,48,', '3');
INSERT INTO `es_menu` VALUES ('49', '46', '焦点图管理', null, 'pcFocusManage', '/admin/focus-pictures.*', '0', ',6,46,49,', '3');
INSERT INTO `es_menu` VALUES ('50', '6', '移动端装修', null, 'mobileDecoration', '/page.*', '0', ',6,50,', '2');
INSERT INTO `es_menu` VALUES ('52', '50', '楼层装修', '', 'mobileFloorManage', '/admin/pages.*', '0', ',6,50,52,', '3');
INSERT INTO `es_menu` VALUES ('53', '50', '焦点图管理', null, 'mobileFocusManage', '/admin/focus-pictures.*', '0', ',6,50,53,', '3');
INSERT INTO `es_menu` VALUES ('54', '6', '页面设置', null, 'pageSetting', '/page.*', '0', ',6,54,', '2');
INSERT INTO `es_menu` VALUES ('55', '54', 'PC导航菜单', null, 'pcSiteMenu', '/admin/pages/site-navigations.*', '0', ',6,54,55,', '3');
INSERT INTO `es_menu` VALUES ('56', '54', '移动端导航菜单', null, 'mobileSiteMenu', '/admin/pages/site-navigations.*', '0', ',6,54,56,', '3');
INSERT INTO `es_menu` VALUES ('57', '54', '热门关键字', null, 'hotKeyword', '/admin/pages/hot-keywords.*', '0', ',6,54,57,', '3');
INSERT INTO `es_menu` VALUES ('61', '7', '会员分析', null, 'memberAnalysis', '/statistics.*', '0', ',7,61,', '2');
INSERT INTO `es_menu` VALUES ('62', '61', '会员下单量', '', 'orderAmount', '/admin/statistics.*', '0', ',7,61,62,', '3');
INSERT INTO `es_menu` VALUES ('63', '61', '新增会员统计', '', 'addedMember', '/admin/statistics.*', '0', ',7,61,63,', '3');
INSERT INTO `es_menu` VALUES ('64', '7', '商品统计', null, 'goodsStatistics', '/statistic.*', '0', ',7,64,', '2');
INSERT INTO `es_menu` VALUES ('65', '64', '价格销量', null, 'priceSales', '(/admin/shops.*)|(/admin/goods.*)|(/admin/statistics.*)', '0', ',7,64,65,', '3');
INSERT INTO `es_menu` VALUES ('66', '64', '热卖商品统计', null, 'hotGoods', '(/admin/shops.*)|(/admin/goods.*)|(/admin/statistics.*)', '0', ',7,64,66,', '3');
INSERT INTO `es_menu` VALUES ('67', '64', '商品销售明细', null, 'goodsSalesDetails', '(/admin/shops.*)|(/admin/goods.*)|(/admin/statistics.*)', '0', ',7,64,67,', '3');
INSERT INTO `es_menu` VALUES ('68', '64', '商品收藏统计', null, 'goodsCollect', '(/admin/shops.*)|(/admin/goods.*)|(/admin/statistics.*)', '0', ',7,64,68,', '3');
INSERT INTO `es_menu` VALUES ('69', '7', '行业分析', null, 'industryAnalysis', '/statistic.*', '0', ',7,69,', '2');
INSERT INTO `es_menu` VALUES ('70', '69', '行业规模', null, 'industryScale', '(/admin/shops.*)|(/admin/statistics.*)', '0', ',7,69,70,', '3');
INSERT INTO `es_menu` VALUES ('71', '69', '概括总览', null, 'generalityOverview', '(/admin/shops.*)|(/admin/statistics.*)', '0', ',7,69,71,', '3');
INSERT INTO `es_menu` VALUES ('72', '7', '流量分析', null, 'trafficAnalysis', '/admin/statistics.*', '0', ',7,72,', '2');
INSERT INTO `es_menu` VALUES ('73', '72', '店铺流量分析', '', 'trafficAnalysisShop', '(/admin/shops.*)|(/admin/statistics.*)', '0', ',7,72,73,', '3');
INSERT INTO `es_menu` VALUES ('74', '72', '商品流量分析', '', 'trafficAnalysisGoods', '(/admin/shops.*)|(/admin/statistics.*)', '0', ',7,72,74,', '3');
INSERT INTO `es_menu` VALUES ('75', '7', '其它统计', null, 'otherStatistics', '/statistics.*', '0', ',7,75,', '2');
INSERT INTO `es_menu` VALUES ('76', '75', '订单统计', null, 'orderStatistics', '(/admin/shops.*)|(/admin/statistics.*)', '0', ',7,75,76,', '3');
INSERT INTO `es_menu` VALUES ('77', '75', '销售收入统计', null, 'salesRevenueStatistics', '(/admin/shops.*)|(/admin/statistics.*)', '0', ',7,75,77,', '3');
INSERT INTO `es_menu` VALUES ('78', '75', '区域分析', null, 'regionalAnalysis', '(/admin/shops.*)|(/admin/statistics.*)', '0', ',7,75,78,', '3');
INSERT INTO `es_menu` VALUES ('79', '75', '客单价分布图', null, 'customerPriceDistribution', '(/admin/shops.*)|(/admin/goods/categories.*)|(/admin/statistics.*)', '0', ',7,75,79,', '3');
INSERT INTO `es_menu` VALUES ('80', '75', '退款统计', null, 'refundStatistics', '(/admin/shops.*)|(/admin/statistics/order/return.*)', '0', ',7,75,80,', '3');
INSERT INTO `es_menu` VALUES ('82', '8', '网店设置', null, 'shopSettings', '/system.*', '0', ',8,82,', '2');
INSERT INTO `es_menu` VALUES ('83', '82', '系统设置', null, 'systemSettings', '(/admin/settings.*)|(/admin/goods.*)|(/admin/trade.*)', '0', ',8,82,83,', '3');
INSERT INTO `es_menu` VALUES ('84', '82', 'SMTP设置', null, 'smtpSettings', '/admin/systems/smtps.*', '0', ',8,82,84,', '3');
INSERT INTO `es_menu` VALUES ('85', '82', '短信网关设置', '', 'smsGatewaySettings', '/admin/systems/platforms.*', '0', ',8,82,85,', '3');
INSERT INTO `es_menu` VALUES ('86', '82', '快递平台设置', null, 'expressPlatformSettings', '/admin/systems/express-platforms.*', '0', ',8,82,86,', '3');
INSERT INTO `es_menu` VALUES ('88', '82', '电子面单', '', 'electronicrEceipt', '/admin/systems/waybills.*', '0', ',8,82,88,', '3');
INSERT INTO `es_menu` VALUES ('89', '82', '储存方案', '', 'storageSolution', '/admin/systems/uploaders.*', '0', ',8,82,89,', '3');
INSERT INTO `es_menu` VALUES ('90', '82', '静态页', '', 'staticPage', '(/admin/task.*)|(/admin/page-create.*)', '0', ',8,82,90,', '3');
INSERT INTO `es_menu` VALUES ('91', '82', '商品索引', '', 'goodsIndex', '(/admin/task.*)|(/admin/goods/search.*)', '0', ',8,82,91,', '3');
INSERT INTO `es_menu` VALUES ('92', '82', '信任登录', '', 'trustLogin', '/admin/members/connect.*', '0', ',8,82,92,', '3');
INSERT INTO `es_menu` VALUES ('94', '8', '消息设置', null, 'messageSettings', '/system.*', '0', ',8,94,', '2');
INSERT INTO `es_menu` VALUES ('95', '94', '店铺消息', null, 'shopMessageSettings', '/admin/systems/message-templates.*', '0', ',8,94,95,', '3');
INSERT INTO `es_menu` VALUES ('96', '94', '会员消息', null, 'memberMessageSettings', '/admin/systems/message-templates.*', '0', ',8,94,96,', '3');
INSERT INTO `es_menu` VALUES ('106', '9', '菜单管理', '', 'toolManage', '/admin/systems/menus.*', '0', ',9,106,', '2');
INSERT INTO `es_menu` VALUES ('111', '9', '文章管理', null, 'articleManage', '/system.*', '0', ',9,111,', '2');
INSERT INTO `es_menu` VALUES ('113', '111', '文章列表', null, 'articleList', '(/admin/systems/admin-users.*)|(/admin/pages.*)', '0', ',9,111,113,', '3');
INSERT INTO `es_menu` VALUES ('179', '111', '文章分类', 'xxx', 'articleCategory', '/admin/pages/article-categories.*', '0', null, null);
INSERT INTO `es_menu` VALUES ('180', '8', '推送设置', 'xxx', 'pushSettings', '/admin/systems.*', '0', ',8,180,', '2');
INSERT INTO `es_menu` VALUES ('181', '180', '商品推送', 'xxx', 'goodsPush', '/admin/systems.*', '0', null, null);
INSERT INTO `es_menu` VALUES ('182', '180', 'APP推送', 'xxx', 'appPush', '/admin/systems.*', '0', null, null);
INSERT INTO `es_menu` VALUES ('185', '2', '收款单', '', 'collectionList', '/admin/trade/orders/pay-log.*', '0', ',2,185,', '2');
INSERT INTO `es_menu` VALUES ('186', '2', '开票历史', '', 'receiptHistory', '/admin/members/receipts.*', '0', ',2,186,', '2');
INSERT INTO `es_menu` VALUES ('187', '3', '站内消息', '', 'memberNotification', '/admin/systems/messages.*', '0', ',3,187,', '2');
INSERT INTO `es_menu` VALUES ('188', '4', '店铺结算管理', '', 'settlementManage', '/admin/order/bills.*', '0', ',4,188,', '2');
INSERT INTO `es_menu` VALUES ('189', '5', '限时抢购', '', 'seckillManage', '/admin/promotion.*', '0', ',5,189,', '2');
INSERT INTO `es_menu` VALUES ('190', '8', '支付和配送', null, 'paymentAndDelivery', '/system.*', '0', ',8,190,', '2');
INSERT INTO `es_menu` VALUES ('191', '190', '支付方式', null, 'paymentSettings', '(/base-api/uploaders.*)|(/admin/payment/payment-methods.*)', '0', ',8,190,191,', '3');
INSERT INTO `es_menu` VALUES ('192', '190', '物流公司', null, 'expressSettings', '/admin/systems/logi-companies.*', '0', ',8,190,192,', '3');
INSERT INTO `es_menu` VALUES ('193', '190', '区域管理', null, 'regionalManagementSettings', '/base-api/regions.*', '0', ',8,190,193,', '3');
INSERT INTO `es_menu` VALUES ('194', '8', '权限管理', null, 'authSettings', '/system.*', '0', ',8,194,', '2');
INSERT INTO `es_menu` VALUES ('195', '194', '管理员管理', null, 'administratorManage', '(/base-api/uploaders.*)|(/admin/systems/manager/admin-users.*)|(/admin/systems/roles.*)|(/system.*)', '0', ',8,194,195,', '3');
INSERT INTO `es_menu` VALUES ('196', '194', '角色管理', null, 'roleManage', '(/admin/systems/roles.*)|(/admin/systems/menus.*)', '0', ',8,194,196,', '3');
INSERT INTO `es_menu` VALUES ('197', '0', '分销管理', null, 'distribution', '/distribution.*', '0', ',197,', '1');
INSERT INTO `es_menu` VALUES ('198', '197', '提成模板', '', 'extractTpl', '/distribution.*', '0', ',197,198,', '2');
INSERT INTO `es_menu` VALUES ('199', '197', '个人分销商', '', 'distributorList', '/admin/distribution.*', '-1', ',197,199,', '2');
INSERT INTO `es_menu` VALUES ('200', '197', '业绩列表', '', 'achievement', '/admin/distribution.*', '-1', ',197,200,', '2');
INSERT INTO `es_menu` VALUES ('201', '197', '提现管理', null, 'distributionSettings', '/admin/distribution.*', '-1', ',197,201,', '2');
INSERT INTO `es_menu` VALUES ('202', '198', '个人提成模板', '', 'perAccomplishmentTpl', '/admin/distribution.*', '0', ',197,198,202,', '3');
INSERT INTO `es_menu` VALUES ('203', '198', '升级日志', '', 'upgradeLogs', '/distribution.*', '0', ',197,198,203,', '3');
INSERT INTO `es_menu` VALUES ('204', '201', '提现设置', null, 'withdrawSettings', '/admin/distribution.*', '-1', ',197,201,204,', '3');
INSERT INTO `es_menu` VALUES ('206', '197', '分销商管理', '', 'distributor', '/distribution.*', '0', ',197,206,', '2');
INSERT INTO `es_menu` VALUES ('207', '206', '个人分销商', '', 'distributorList', '/distribution.*', '0', ',197,206,207,', '3');
INSERT INTO `es_menu` VALUES ('208', '206', '分销商统计', '', 'distributorStatistics', '/distribution.*', '0', ',197,206,208,', '3');
INSERT INTO `es_menu` VALUES ('209', '197', '业绩管理', '', 'achievement', '/distribution.*', '0', ',197,209,', '2');
INSERT INTO `es_menu` VALUES ('210', '209', '业绩列表', '', 'achievementList', '/distribution.*', '0', ',197,209,210,', '3');
INSERT INTO `es_menu` VALUES ('211', '209', '账单列表', '', 'billList', '/distribution.*', '0', ',197,209,211,', '3');
INSERT INTO `es_menu` VALUES ('212', '209', '结算单详情', '', 'billDetails', '/distribution.*', '0', ',197,209,212,', '3');
INSERT INTO `es_menu` VALUES ('213', '197', '提现管理', '', 'putforwardManage', '/distribution.*', '0', ',197,213,', '2');
INSERT INTO `es_menu` VALUES ('214', '213', '提现设置', '', 'putforwardSettings', '/distribution.*', '0', ',197,213,214,', '3');
INSERT INTO `es_menu` VALUES ('215', '213', '提现申请', '', 'putforwardApply', '/distribution.*', '0', ',197,213,215,', '3');
INSERT INTO `es_menu` VALUES ('216', '189', '限时抢购', '', 'seckillList', '/admin/promotion.*', '0', ',5,189,216,', '3');
INSERT INTO `es_menu` VALUES ('217', '187', '站内消息', '', 'notificationHistory', '/admin/systems/messages.*', '0', ',3,187,217,', '3');
INSERT INTO `es_menu` VALUES ('218', '106', '菜单管理', null, 'menuManage', '/admin/systems/menus.*', '0', ',9,106,218,', '3');
INSERT INTO `es_menu` VALUES ('219', '188', '店铺结算单', '', 'settlement', '/admin/order/bills.*', '0', ',4,188,219,', '3');
INSERT INTO `es_menu` VALUES ('220', '2', '资质审核', null, 'receiptExamine', '/admin/members/zpzz.*', '0', ',2,220,', '2');
INSERT INTO `es_menu` VALUES ('221', '5', '拼团管理', '', 'assembleManage', '/admin/promotion.*', '0', ',5,221,', '2');
INSERT INTO `es_menu` VALUES ('222', '221', '拼团活动', null, 'assembleList', '/admin/promotion/pintuan.*', '0', ',5,221,222,', '3');
INSERT INTO `es_menu` VALUES ('223', '94', '微信消息', null, 'wechatMessage', '/admin/systems/wechat-msg-tmp.*', '0', ',8,94,223,', '3');
INSERT INTO `es_menu` VALUES ('224', '8', '搜索设置', null, 'searchSettings', '/admin/goodssearch.*', '0', ',8,224,', '2');
INSERT INTO `es_menu` VALUES ('225', '224', '搜索分词', null, 'searchKeyword', '/admin/goodssearch.*', '0', ',8,224,225,', '3');
INSERT INTO `es_menu` VALUES ('226', '224', '搜索历史', null, 'searchHistory', '/admin/goodssearch.*', '0', ',8,224,226,', '3');
INSERT INTO `es_menu` VALUES ('227', '224', '搜索提示词', null, 'searchTips', '/admin/goodssearch.*', '0', ',8,224,227,', '3');
INSERT INTO `es_menu` VALUES ('228', '2', '售后服务列表', null, 'serviceList', '/admin/after-sales.*', '0', ',2,228,', '2');
INSERT INTO `es_menu` VALUES ('229', '2', '投诉', null, 'complaint', '/admin/trade/order-complains.*', '0', ',2,229,', '2');
INSERT INTO `es_menu` VALUES ('230', '229', '投诉列表', null, 'complaintList', '/admin/trade/order-complains.*', '0', ',2,229,230,', '3');
INSERT INTO `es_menu` VALUES ('231', '229', '投诉主题', null, 'subjectList', '/admin/systems/complain-topics.*', '0', ',2,229,231,', '3');
INSERT INTO `es_menu` VALUES ('232', '82', '敏感词', null, 'sensitiveWords', '/admin/sensitive-words.*', '0', ',8,82,232,', '3');
INSERT INTO `es_menu` VALUES ('233', '5', '优惠券', null, 'couponManage', '/admin/promotion/coupons.*', '0', ',5,233,', '2');

-- ----------------------------
-- Table structure for `es_message`
-- ----------------------------
DROP TABLE IF EXISTS `es_message`;
CREATE TABLE `es_message` (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '站内消息主键',
  `title` varchar(100) DEFAULT NULL COMMENT '标题',
  `content` longtext COMMENT '消息内容',
  `member_ids` longtext COMMENT '会员id',
  `admin_id` int(8) DEFAULT NULL COMMENT '管理员id',
  `admin_name` varchar(50) DEFAULT NULL COMMENT '管理员名称',
  `send_time` bigint(20) DEFAULT NULL COMMENT '发送时间',
  `send_type` int(2) DEFAULT NULL COMMENT '发送类型',
  `disabled` int(2) DEFAULT 0 COMMENT '是否删除 0：否，1：是',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='站内消息(es_message)';

-- ----------------------------
-- Records of es_message
-- ----------------------------

-- ----------------------------
-- Table structure for `es_message_template`
-- ----------------------------
DROP TABLE IF EXISTS `es_message_template`;
CREATE TABLE `es_message_template` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '模版ID',
  `tpl_code` varchar(255) DEFAULT NULL COMMENT '模版编号',
  `tpl_name` varchar(255) DEFAULT NULL COMMENT '模板名称',
  `type` varchar(10) DEFAULT NULL COMMENT '类型(会员 ,店铺 ,其他)',
  `notice_state` varchar(10) DEFAULT '1' COMMENT '站内信提醒是否开启',
  `sms_state` varchar(10) DEFAULT '1' COMMENT '短信提醒是否开启',
  `email_state` varchar(10) DEFAULT '1' COMMENT '邮件提醒是否开启',
  `content` longtext COMMENT '站内信内容',
  `sms_content` longtext COMMENT '短信内容',
  `email_content` longtext COMMENT '邮件内容',
  `email_title` varchar(50) DEFAULT NULL COMMENT '邮件标题',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='消息模版(es_message_template)';

-- ----------------------------
-- Records of es_message_template
-- ----------------------------
INSERT INTO `es_message_template` VALUES ('1', 'SHOPORDERSNEW', '新订单提醒', 'SHOP', 'OPEN', 'CLOSED', 'CLOSED', '您的新订单：订单单号${ordersSn}于${createTime}生成，请进入商户中心订单管理查看。测试一下', '新订单提示：您的订单：订单单号${ordersSn}于${createTime}生成，请登录商户中心订单管理查看。', '<p>${siteName}】新订单提示：您的订单：订单单号${ordersSn}于${createTime}生成，请登录商户中心订单管理查看。</p>', '新订单提醒');
INSERT INTO `es_message_template` VALUES ('2', 'SHOPORDERSPAY', '订单支付提醒', 'SHOP', 'OPEN', 'CLOSED', 'CLOSED', '您的订单：订单单号${ordersSn}已于${paymentTime}支付成功，请及时进入商户中心商品订单发货。', '订单提示：订单单号${ordersSn}已于${paymentTime}支付成功，请及时登录商户中心商品订单发货。', '<p>${siteName}订单提示：您的订单单号${ordersSn}已于${paymentTime}支付成功，请及时登录商户中心商品订单发货。</p>', '订单支付提醒');
INSERT INTO `es_message_template` VALUES ('3', 'SHOPORDERSRECEIVE', '订单收货提醒', 'SHOP', 'OPEN', 'CLOSED', 'CLOSED', '您的订单：订单单号${ordersSn}已于${finishTime}收货完成，请进入商户中心商品订单查看。', '订单提示：订单单号${ordersSn}已于${finishTime}收货完成，请登录商户中心商品订单查看。', '<p>${siteName}订单提示：您的订单单号${ordersSn}已于${finishTime}收货完成，请登录商户中心商品订单查看。</p>', '订单收货提醒');
INSERT INTO `es_message_template` VALUES ('4', 'SHOPORDERSEVALUATE', '买家评价提醒', 'SHOP', 'OPEN', 'CLOSED', 'CLOSED', '您的订单：订单单号${sn}已被买家${member_name}评价，请进入商户中心评价管理查看。', '订单提示：您的订单单号${ordersSn}已被买家${userName}于${evalTime}评价，请登录商户中心评价管理查看。', '<p>订单提示：您的订单单号：${ordersSn}已被买家${userName}于${evalTime}评价，请登录商户中心评价管理查看。</p>', '买家评价提醒');
INSERT INTO `es_message_template` VALUES ('5', 'SHOPORDERSCANCEL', '订单取消提醒', 'SHOP', 'OPEN', 'CLOSED', 'CLOSED', '您的订单：订单单号${ordersSn}已于${cancelTime}取消，请进入商户中心商品订单查看。', '订单提示：订单单号${ordersSn}已于${cancelTime}取消，请登录商户中心商品订单查看。', '<p>订单提示：您的订单：订单单号${ordersSn}已于${cancelTime}取消，请登录商户中心商品订单查看。</p>', '订单取消提醒');
INSERT INTO `es_message_template` VALUES ('6', 'SHOPREFUND', '退款提醒', 'SHOP', 'OPEN', 'CLOSED', 'CLOSED', '您的新退款：退款单号${refundSn}需要处理，请进入商户中心退款记录查看。', '新退款提示：退款单号${refundSn}需要处理，请登录商户中心退款记录查看。', '<p>新退款提示：退款单号${refundSn}需要处理，请登录商户中心退款记录查看。</p>', '退款提醒');
INSERT INTO `es_message_template` VALUES ('7', 'SHOPRETURN', '退货提醒', 'SHOP', 'OPEN', 'CLOSED', 'CLOSED', '您的新退货：退货单号${refundSn}需要处理，请进入商户中心退款记录查看。', '新退货提示：退货单号${refundSn}需要处理，请登录商户中心退货记录查看。', '<p>新退货提示：退货单号${refundSn}需要处理，请登录商户中心退货记录查看。</p>', '退货提醒');
INSERT INTO `es_message_template` VALUES ('8', 'SHOPGOODSVERIFY', '商品审核失败提醒', 'SHOP', 'OPEN', 'CLOSED', 'CLOSED', '您的商品：商品：${name}没有通过管理员审核，原因是：${message}，请进入商户中心仓库中的商品查看。', '商品提示：您的商品${name}没有通过管理员审核，原因是：${message}，请登录商户中心仓库中的商品查看。', '<p>商品提示：您的商品${name}没有通过管理员审核，原因是：${message}，请登录商户中心仓库中的商品查看。</p>', '商品审核失败提醒');
INSERT INTO `es_message_template` VALUES ('9', 'MEMBERORDERSCANCEL', '订单取消提醒', 'MEMBER', 'OPEN', 'CLOSED', 'CLOSED', '您的订单：订单单号${ordersSn}已于${cancelTime}取消，请进入用户中心商品订单查看。', '订单提示：您订单单号${ordersSn}已于${cancelTime}取消，请登录用户中心商品订单查看。', '<p>订单提示：您订单单号${ordersSn}已于${cancelTime}取消，请登录用户中心商品订单查看。</p>', '订单取消提醒');
INSERT INTO `es_message_template` VALUES ('10', 'MEMBERORDERSPAY', '订单支付提醒', 'MEMBER', 'OPEN', 'CLOSED', 'CLOSED', '您的订单：订单单号${ordersSn}已于${paymentTime}付款成功，请进入用户中心商品订单查看。。。。', '订单提示：您订单单号${ordersSn}已于${paymentTime}付款成功，请登录用户中心商品订单查看。', '<p><span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\"><span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${siteName}</span><span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">订单</span><span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">提示：</span></p><p style=\"white-space: normal; word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">您的订单单号<span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${ordersSn}已于<span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${paymentTime}付款成功，请登录用户中心商品订单查看。</p><p><br/></p>', '订单支付提醒');
INSERT INTO `es_message_template` VALUES ('11', 'MEMBERORDERSRECEIVE', '订单收货提醒', 'MEMBER', 'OPEN', 'CLOSED', 'CLOSED', '您的订单：订单单号${ordersSn}已于${finishTime}收货完成，请进入商户中心商品订单查看。', '订单提示：订单单号${ordersSn}已于${finishTime}收货完成，请登录商户中心商品订单查看。', '<p><span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span><span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">${siteName}</span><span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">订单</span><span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">提示：</span></p><p style=\"white-space: normal; word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">您的订单单号<span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${ordersSn}已于<span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${finishTime}收货完成，请登录用户中心商品订单查看。</p><p><br/></p>', '订单收货提醒');
INSERT INTO `es_message_template` VALUES ('12', 'MEMBERORDERSSEND', '订单发货提醒', 'MEMBER', 'OPEN', 'CLOSED', 'CLOSED', '您的订单：订单单号${ordersSn}已于${sendTime}发货，运单号：${shipSn}。请进入用户中心商品订单查看。', '您的订单：订单单号${ordersSn}已于${sendTime}发货，运单号：${shipSn}。请登录用户中心商品订单查看。', '<p style=\"white-space: normal; word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; line-height: 18px;\"><span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica;\"></span>${siteName}订单提示：</p><p style=\"white-space: normal; word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; line-height: 18px;\"><span style=\"font-family: sans-serif;\">您的订单单号${ordersSn}已于${sendTime}发货，运单号：${shipSn}。请登录用户中心商品订单查看。</span></p>', '订单发货提醒');
INSERT INTO `es_message_template` VALUES ('13', 'MEMBERREFUNDUPDATE', '售后服务退款提醒', 'MEMBER', 'OPEN', 'CLOSED', 'CLOSED', '售后服务退款提醒：您编号为${serviceSn}的${serviceType}售后服务正在进行退款，请进入个人中心-售后服务中查看详细信息。', '售后服务退款提醒：您编号为${serviceSn}的${serviceType}售后服务正在进行退款，请进入个人中心-售后服务中查看详细信息。', '<p style=\"word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px; white-space: normal;\"><span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${siteName}售后服务退款提醒：</p><p style=\"word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px; white-space: normal;\">您编号为<span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${serviceSn}的${serviceType}售后服务正在进行退款，请进入个人中心-售后服务中查看详细信息。</p>', '售后服务退款提醒');
INSERT INTO `es_message_template` VALUES ('14', 'MEMBERRETURNUPDATE', '退货提醒', 'MEMBER', 'OPEN', 'CLOSED', 'CLOSED', '您的退货：退单单号${refundSn}的售后申请已有变化，请进入用户中心售后退货服务查看。', '退货提示：您的退单单号${refundSn}的售后申请已有变化，请进入用户中心售后退货服务查看。', '<p style=\"word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px; white-space: normal; text-align: left;\"><span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${siteName}退货提示：</p><p style=\"white-space: normal; word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">您的<span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\"></span>退单单号<span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${refundSn}的售后申请已有变化，请登录用户中心售后退款服务查看。</p><p><br/></p>', '退货提醒');
INSERT INTO `es_message_template` VALUES ('15', 'MEMBERLOGINSUCCESS', '会员登录成功', 'MEMBER', 'OPEN', 'CLOSED', 'CLOSED', '登录提示：您的会员${name}于${loginTime}登录成功！', '登录提示：您的会员${name}于${loginTime}登录成功！', '<p style=\"word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px; white-space: normal; text-align: left;\"><span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${siteName}登录提示：</p><p style=\"white-space: normal; word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">您的<span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\"></span>会员<span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${name}于${loginTime}登录成功！</p><p><br/></p>', '会员登录提醒 ');
INSERT INTO `es_message_template` VALUES ('16', 'MEMBERREGISTESUCCESS', '会员注册成功', 'MEMBER', 'CLOSED', 'CLOSED', 'CLOSED', '注册提示：您的会员${name}于${loginTime}注册成功！', '注册提示：您的会员${name}于${loginTime}注册成功！', '<p style=\"word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px; white-space: normal; text-align: left;\"><span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${siteName}注册提示：</p><p style=\"white-space: normal; word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">您的<span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\"></span>会员<span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${name}于${loginTime}注册成功！</p><p><br/></p>', '会员注册提醒 ');
INSERT INTO `es_message_template` VALUES ('17', 'MOBILECODESEND', '手机发送验证码', 'MEMBER', 'CLOSED', 'CLOSED', 'CLOSED', '您正在${byName}，验证码是：${code}。', '您正在${byName}，验证码是：${code}。', '<p style=\"word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px; white-space: normal; text-align: left;\"><span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\">${siteName}</span>您正在${byName}，</p><p style=\"white-space: normal; word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">您的<span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\"></span>验证码是：<span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\">${code}。</span></p><p><br/></p>', '发送验证码');
INSERT INTO `es_message_template` VALUES ('18', 'SHOPGOODSMARKETENABLE', '商品下架消息提醒', 'SHOP', 'CLOSED', 'CLOSED', 'CLOSED', '您的商品：${name}  已被管理员下架，原因是：${reason}。请在客服中的商品相关消息查看详细。', '您的商品：${name}  已被管理员下架，原因是：${reason}。请在客服中的商品相关消息查看详细。', '<p>${siteName}您的商品：${name}&nbsp; 已被管理员下架，原因是：${reason}。请在客服中的商品相关消息查看详细。</p>', '商品下架消息提醒');
INSERT INTO `es_message_template` VALUES ('19', 'MEMBERORDERCREATE', '订单创建提醒', 'MEMBER', 'OPEN', 'CLOSED', 'CLOSED', '订单提示：您于${createTime}成功创建了订单单号为${ordersSn}的订单，请进入用户中心商品订单查看。', '订单提示：您于${createTime}成功创建了订单单号为${ordersSn}的订单，请进入用户中心商品订单查看。', '<p><span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\"><span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${siteName}</span><span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">订单</span><span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">提示：</span></p><p style=\"white-space: normal; word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">您订单单号为<span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${ordersSn}的订单已于<span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\"></span>${createTime}创建成功，请登录用户中心商品订单查看。</p><p><br/></p>', '订单创建提醒');
INSERT INTO `es_message_template` VALUES ('20', 'EMAILCODESEND', '邮箱发送验证码', 'MEMBER', 'CLOSED', 'CLOSED', 'CLOSED', '您正在进行${byName}，验证码是：${code}。', '您正在进行${byName}，验证码是：${code}。', '<p style=\"word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px; white-space: normal; text-align: left;\"><span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\">${siteName}</span>您正在进行${byName}，</p><p style=\"white-space: normal; word-wrap: break-word; font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\">您的<span style=\"font-family: &#39;sans serif&#39;, tahoma, verdana, helvetica; font-size: 12px; line-height: 18px;\"></span>验证码是：<span style=\"font-family: &quot;sans serif&quot;, tahoma, verdana, helvetica; font-size: 12px;\">${code}。</span></p><p><br/></p>', '邮件验证码');
INSERT INTO `es_message_template` VALUES ('21', 'SHOPGOODSASK', '买家咨询提醒', 'SHOP', 'OPEN', 'CLOSED', 'CLOSED', '商品咨询提醒：买家${memberName}于${askTime}对店铺中商品名称为${goodsName}的商品进行了咨询，请进入商户中心咨询管理查看。', '商品咨询提醒：买家${memberName}于${askTime}对店铺中商品名称为${goodsName}的商品进行了咨询，请进入商户中心咨询管理查看。', '<p>商品咨询提醒：买家${memberName}于${askTime}对店铺中商品名称为${goodsName}的商品进行了咨询，请进入商户中心咨询管理查看。</p>', '买家咨询提醒');
INSERT INTO `es_message_template` VALUES ('22', 'SHOPAFTERSALE', '订单申请售后服务提醒', 'SHOP', 'OPEN', 'CLOSED', 'CLOSED', '售后申请提醒：编号为${orderSn}的订单申请了${serviceType}售后服务，售后服务单号为${serviceSn}，请进入商家中心维权订单中查看。', '售后申请提醒：编号为${orderSn}的订单申请了${serviceType}售后服务，售后服务单号为${serviceSn}，请进入商家中心维权订单中查看。', '<p>售后申请提醒：编号为${orderSn}的订单申请了${serviceType}售后服务，售后服务单号为${serviceSn}，请进入商家中心维权订单中查看。</p>', '订单申请售后服务提醒');
INSERT INTO `es_message_template` VALUES ('23', 'SHOPAFTERSALEGOODSSHIP', '买家退还售后商品提醒', 'SHOP', 'OPEN', 'CLOSED', 'CLOSED', '买家退还售后商品提醒：编号为${serviceSn}的${serviceType}售后服务，买家已将申请售后服务的商品寄出，物流单号为${courierNumber}，请进入商家中心维权订单中查看。', '买家退还售后商品提醒：编号为${serviceSn}的${serviceType}售后服务，买家已将申请售后服务的商品寄出，物流单号为${courierNumber}，请进入商家中心维权订单中查看。', '<p>买家退还售后商品提醒：编号为${serviceSn}的${serviceType}售后服务，买家已将申请售后服务的商品寄出，物流单号为${courierNumber}，请进入商家中心维权订单中查看。</p>', '买家退还售后商品提醒');
INSERT INTO `es_message_template` VALUES ('24', 'MEMBERASAUDIT', '售后服务申请审核提醒', 'MEMBER', 'OPEN', 'CLOSED', 'CLOSED', '售后服务申请审核提醒：您编号为${serviceSn}的${serviceType}售后服务申请${auditStatus}，请进入个人中心-售后服务中查看详细信息。', '售后服务申请审核提醒：您编号为${serviceSn}的${serviceType}售后服务申请${auditStatus}，请进入个人中心-售后服务中查看详细信息。', '<p>售后服务申请审核通过提醒：您编号为${serviceSn}的${serviceType}售后服务申请${auditStatus}，请进入个人中心-售后服务中查看详细信息。</p>', '售后服务申请审核提醒');
INSERT INTO `es_message_template` VALUES ('25', 'MEMBERASCOMPLETED', '售后服务完成提醒', 'MEMBER', 'OPEN', 'CLOSED', 'CLOSED', '售后服务完成提醒：您编号为${serviceSn}的${serviceType}售后服务已完成，请进入个人中心-售后服务中查看详细信息。', '售后服务完成提醒：您编号为${serviceSn}的${serviceType}售后服务已完成，请进入个人中心-售后服务中查看详细信息。', '<p>售后服务完成提醒：您编号为${serviceSn}的${serviceType}售后服务已完成，请进入个人中心-售后服务中查看详细信息。</p>', '售后服务完成提醒');
INSERT INTO `es_message_template` VALUES ('26', 'MEMBERASAUDITRETURNCHANGE', '退货和换货售后服务审核通过提醒', 'MEMBER', 'OPEN', 'OPEN', 'CLOSED', '售后服务申请审核通过提醒：您编号为${serviceSn}的${serviceType}售后服务申请商家已审核通过，请尽快将商品退还给卖家，退货地址为【${returnAddr}】。', '售后服务申请审核通过提醒：您编号为${serviceSn}的${serviceType}售后服务申请商家已审核通过，请尽快将商品退还给卖家，退货地址为【${returnAddr}】。', '<p>售后服务申请审核通过提醒：您编号为${serviceSn}的${serviceType}售后服务申请商家已审核通过，请尽快将商品退还给卖家，退货地址为【${returnAddr}】。</p>', '退货和换货售后服务审核通过提醒');
INSERT INTO `es_message_template` VALUES ('27', 'MEMBERASCLOSED', '售后服务单关闭提醒', 'MEMBER', 'OPEN', 'CLOSED', 'CLOSED', '售后服务单关闭提醒：您编号为${serviceSn}的${serviceType}售后服务单已被商家关闭，具体信息请进入售后服务详情中查看。', '售后服务单关闭提醒：您编号为${serviceSn}的${serviceType}售后服务单已被商家关闭，具体信息请进入售后服务详情中查看。', '<p>售后服务单关闭提醒：您编号为${serviceSn}的${serviceType}售后服务单已被商家关闭，具体信息请进入售后服务详情中查看。</p>', '售后服务单关闭提醒');
INSERT INTO `es_message_template` VALUES ('28', 'PINTUANORDERAUTOCANCEL', '拼团订单自动取消提醒', 'MEMBER', 'OPEN', 'CLOSED', 'CLOSED', '拼团订单自动取消提醒：您编号为${orderSn}的拼团订单在活动结束时未能成团，因此被系统自动取消并已成功退款，如有问题请联系商家或平台。', '拼团订单自动取消提醒：您编号为${orderSn}的拼团订单在活动结束时未能成团，因此被系统自动取消并已成功退款，如有问题请联系商家或平台。', '<p>拼团订单自动取消提醒：您编号为${orderSn}的拼团订单在活动结束时未能成团，因此被系统自动取消并已成功退款，如有问题请联系商家或平台。</p>', '拼团订单自动取消提醒');

-- ----------------------------
-- Table structure for `es_page`
-- ----------------------------
DROP TABLE IF EXISTS `es_page`;
CREATE TABLE `es_page` (
  `page_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `page_name` varchar(255) DEFAULT NULL COMMENT '楼层名称',
  `page_data` longtext COMMENT '楼层数据',
  `page_type` varchar(20) DEFAULT NULL COMMENT '页面类型',
  `client_type` varchar(20) DEFAULT NULL COMMENT '客户端类型',
  PRIMARY KEY (`page_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='楼层(es_page)';

-- ----------------------------
-- Records of es_page
-- ----------------------------
INSERT INTO `es_page` VALUES ('13', '首页', '[     {         \"tpl_id\":23,         \"blockList\":[             {                 \"block_type\":\"IMAGE\",                 \"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/56256727.jpg\"             }         ]     },     {         \"tpl_id\":24,         \"blockList\":[             {                 \"block_type\":\"GOODS\",                 \"block_value\": {                     \"goods_id\":75,                     \"goods_name\":\"促销商品K\",                     \"sn\":\"0074\",                     \"goods_image\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/E1EE42BA506F4A2895B449F661D1644B.jpg_300x300\",                     \"enable_quantity\":100,                     \"quantity\":100,                     \"price\":100.0,                     \"create_time\":1517815032,                     \"market_enable\":1,                     \"brand_name\":\"蜜饯\",                     \"category_name\":\"蜜饯\"                 }             }         ]     },     {         \"tpl_id\":27,         \"blockList\":[             {                 \"block_type\":\"IMAGE\",                 \"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/test/null/4D928A6DABE74EF5A78C2A2E2F5764F7.GIF\",                 \"block_opt\":{                     \"opt_type\":\"keyword\",                     \"opt_value\":\"关键字\",                     \"opt_detail\":\"这是个关键字类型\"                 }             },             {                 \"block_type\":\"IMAGE\",                 \"block_value\":\"\"             }         ]     } ]', 'PC', 'INDEX');
INSERT INTO `es_page` VALUES ('16', 'mobile_floor', '[{\"tpl_id\":23,\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/56256727.jpg\",\"block_opt\":{\"opt_type\":\"GOODS\",\"opt_value\":\"127\"}}]},{\"tpl_id\":32,\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/DBCE90F9FED54013934C7B2D67D8A375.jpg\",\"block_opt\":{\"opt_type\":\"URL\",\"opt_value\":\"/points-mall\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/3EF46BF3BBCA400F98D5E967B0CADA94.jpg\",\"block_opt\":{\"opt_type\":\"URL\",\"opt_value\":\"/group-buy\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/36DD8B5D2EC146CEBED045648CB2D139.jpg\",\"block_opt\":{\"opt_type\":\"GOODS\",\"opt_value\":\"127\"}}]},{\"tpl_id\":26,\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/ED44896D7869493788E96D4A24B975A7.jpg\",\"block_opt\":{\"opt_type\":\"GOODS\",\"opt_value\":\"127\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/83EA781F413C4863A8D5C5691A98AE7E.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"珠宝\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/07D04D85D3CC4F1F82444CCAD46E72DE.jpg\",\"block_opt\":{\"opt_type\":\"CATEGORY\",\"opt_value\":\"494\"}}]},{\"tpl_id\":30,\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/E69978AB440C4A558366734B8094165E.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}}]},{\"tpl_id\":25,\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/8CFCC37CD4A14455AAD3CE630967675D.png\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"居家必备\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/D6A20DB47780409C91CAA7927751CB67.png\",\"block_opt\":{\"opt_type\":\"GOODS\",\"opt_value\":\"127\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/C11C84D00B3C46E98D369711245DE9E8.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"iPhone7红\"}}]},{\"tpl_id\":29,\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/6F48EACC9A3A4D608088564D649DAEE9.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"化妆\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/830E4027C2F24065ABC382D9DD616FD3.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"零食\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/5CE6E68ED7EC4DA8AC4E8F836261CB95.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"运动鞋\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/91D0F362377845D689D4A2673122F4FA.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"户外运动\"}}]},{\"tpl_id\":26,\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/42A2AE1E63794FD79D6C6B8B632C01A3.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"大家电\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/3F80BFFE923347449F91ABA3C87909E4.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"户外运动\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/86F85FB0E29B4863853F206D353F6529.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"母婴用品\"}}]},{\"tpl_id\":23,\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/2006D1FEEF9240C29D968FDF6D31CE05.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"吃货\"}}]},{\"tpl_id\":30,\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/D174AC48C57E4CA9A8903358B2494CAE.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}}]},{\"tpl_id\":32,\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/03A36FB578874299831B4E65DCABEFB2.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"手表\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/FF3331141E504925860F78018A147B06.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"刮胡刀\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/645BDDF5721C4EF2A0435314BF5C0910.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"洗衣机\"}}]},{\"tpl_id\":29,\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/5469BDCB54B8430CA77C5E797E3036B4.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"精品服饰\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/D7557248D85C44E093C6E1A8FDED1EB8.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"户外运动\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/7F3288CABCC64F188ACEE32BEDAC9066.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"达人精选\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/533D9E59BE2D4527BB9908FFAD72B388.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"母婴用品\"}}]},{\"tpl_id\":30,\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/5C791E35C9DE4F969C4DAD9B267324D0.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}}]},{\"tpl_id\":37,\"blockList\":[{\"block_type\":\"GOODS\",\"block_value\":{\"goods_id\":294,\"goods_name\":\"Ferrero Rocher费列罗威化榛仁夹心巧克力T3*16粒装意大利进口婚庆喜糖巧克力礼盒装节日礼物礼品\",\"sn\":\"139606103\",\"thumbnail\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/1DCBCAFDD1464F27A9311AC4710862C3.jpg_300x300\",\"seller_name\":\"平台自营\",\"enable_quantity\":500,\"quantity\":500,\"price\":119,\"create_time\":1509780248,\"market_enable\":1,\"is_auth\":1,\"under_message\":null,\"goods_image\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/1DCBCAFDD1464F27A9311AC4710862C3.jpg_300x300\",\"goods_price\":119},\"block_opt\":\"\"},{\"block_type\":\"GOODS\",\"block_value\":{\"goods_id\":295,\"goods_name\":\"COCA-COLA可口可乐汽水樱桃口味355ml（美国进口 听）*12整箱装\",\"sn\":\"132369864\",\"thumbnail\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/264ABA73530544869DDF2B8DEB745CD3.jpg_300x300\",\"seller_name\":\"平台自营\",\"enable_quantity\":500,\"quantity\":500,\"price\":59,\"create_time\":1509780682,\"market_enable\":1,\"is_auth\":1,\"under_message\":null,\"goods_image\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/264ABA73530544869DDF2B8DEB745CD3.jpg_300x300\",\"goods_price\":59},\"block_opt\":\"\"}]},{\"tpl_id\":37,\"blockList\":[{\"block_type\":\"GOODS\",\"block_value\":{\"goods_id\":297,\"goods_name\":\"南国往事一枕清霜 茶叶 陈年普洱熟茶 七子饼茶 云南普尔茗茶 357g 包邮\",\"sn\":\"122942432\",\"thumbnail\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/0EEB7E9A8D904CF88A3C6AA0B8184574.jpg_300x300\",\"seller_name\":\"平台自营\",\"enable_quantity\":4500,\"quantity\":4500,\"price\":39,\"create_time\":1509784425,\"market_enable\":1,\"is_auth\":1,\"under_message\":null,\"goods_image\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/0EEB7E9A8D904CF88A3C6AA0B8184574.jpg_300x300\",\"goods_price\":39},\"block_opt\":\"\"},{\"block_type\":\"GOODS\",\"block_value\":{\"goods_id\":298,\"goods_name\":\"Apple iPhone 8 Plus 64GB 金色 移动联通电信4G手机\",\"sn\":\"0075\",\"thumbnail\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/63A2A5B98B5E4EAB843B14F33487B40B.jpg_300x300\",\"seller_name\":\"数码家电\",\"enable_quantity\":100,\"quantity\":100,\"price\":6688,\"create_time\":1509787517,\"market_enable\":1,\"is_auth\":1,\"under_message\":null,\"goods_image\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/63A2A5B98B5E4EAB843B14F33487B40B.jpg_300x300\",\"goods_price\":6688},\"block_opt\":\"\"}]},{\"tpl_id\":37,\"blockList\":[{\"block_type\":\"GOODS\",\"block_value\":{\"goods_id\":292,\"goods_name\":\"【内蒙古乌兰察布】草原星 内蒙特产牛肉干手撕500g实惠装 香辣味\",\"sn\":\"166380279\",\"thumbnail\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/6CB518F308D44649BC88119C924868CF.jpg_300x300\",\"seller_name\":\"平台自营\",\"enable_quantity\":9800,\"quantity\":9800,\"price\":69.8,\"create_time\":1509779649,\"market_enable\":1,\"is_auth\":1,\"under_message\":null,\"goods_image\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/6CB518F308D44649BC88119C924868CF.jpg_300x300\",\"goods_price\":69.8},\"block_opt\":\"\"},{\"block_type\":\"GOODS\",\"block_value\":{\"goods_id\":289,\"goods_name\":\"美素佳儿（Friso）金装幼儿配方奶粉 3段（1-3岁幼儿适用）900克（荷兰原装进口）\",\"sn\":\"128232366\",\"thumbnail\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/45A882DB3537498AB2EEE4F9FD90D34E.jpg_300x300\",\"seller_name\":\"平台自营\",\"enable_quantity\":600,\"quantity\":600,\"price\":167,\"create_time\":1509778384,\"market_enable\":1,\"is_auth\":1,\"under_message\":null,\"goods_image\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/45A882DB3537498AB2EEE4F9FD90D34E.jpg_300x300\",\"goods_price\":167},\"block_opt\":\"\"}]},{\"tpl_id\":37,\"blockList\":[{\"block_type\":\"GOODS\",\"block_value\":{\"goods_id\":273,\"goods_name\":\"索尼（SONY）PS4 Slim Pro 正版游戏软件 实体光盘 GTA5 猎车手5\",\"sn\":\"00000130\",\"thumbnail\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/66F34A1B0F8241709D5EA4677D5ABC89.jpg_300x300\",\"seller_name\":\"平台自营\",\"enable_quantity\":100,\"quantity\":100,\"price\":298,\"create_time\":1509357671,\"market_enable\":1,\"is_auth\":1,\"under_message\":null,\"goods_image\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/66F34A1B0F8241709D5EA4677D5ABC89.jpg_300x300\",\"goods_price\":298},\"block_opt\":\"\"},{\"block_type\":\"GOODS\",\"block_value\":{\"goods_id\":266,\"goods_name\":\"Huawei华为麦芒6 4GB+64GB 曜石黑 移动联通电信4G手机\",\"sn\":\"0063\",\"thumbnail\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/0475226BF5D144BAA55B5233964CDCFE.jpg_300x300\",\"seller_name\":\"数码家电\",\"enable_quantity\":99,\"quantity\":100,\"price\":2399,\"create_time\":1509355474,\"market_enable\":1,\"is_auth\":1,\"under_message\":null,\"goods_image\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/demo/0475226BF5D144BAA55B5233964CDCFE.jpg_300x300\",\"goods_price\":2399},\"block_opt\":\"\"}]}]', 'INDEX', 'WAP');
INSERT INTO `es_page` VALUES ('17', 'pc_floor', '[{\"tpl_id\":1,\"tpl_type\":\"ADV\",\"columnList\":[{\"title\":\"家用电器\",\"titleColors\":[\"#0486EF\",\"#04B8F9\"],\"tagList\":[{\"block_type\":\"TEXT\",\"block_value\":\"空气净化器\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"创意礼品\"}},{\"block_type\":\"TEXT\",\"block_value\":\"时尚名包\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"时尚名包\"}},{\"block_type\":\"TEXT\",\"block_value\":\"蓝牙耳机\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"蓝牙耳机\"}},{\"block_type\":\"TEXT\",\"block_value\":\"顶尖好货\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"顶尖好货\"}},{\"block_type\":\"TEXT\",\"block_value\":\"音箱\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"音箱\"}},{\"block_type\":\"TEXT\",\"block_value\":\"扫地机器人\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"扫地机器人\"}},{\"block_type\":\"TEXT\",\"block_value\":\"照相机\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"照相机\"}},{\"block_type\":\"TEXT\",\"block_value\":\"名酒名烟\",\"block_opt\":{\"opt_type\":\"GOODS\",\"opt_value\":\"127\"}},{\"block_type\":\"TEXT\",\"block_value\":\"老冰棍\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"老冰棍\"}}],\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/0551AD3125F242579EEAE9CC525D93B1.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/587150E14A9D44078791CF262889456A.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"美的电饭煲\",\"opt_title\":\"美的电饭煲\",\"opt_desc\":\"填饱你肚子！\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/F0E84E4CEEA04DD9A33D9724BF1CFB9F.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"破壁机\",\"opt_title\":\"破壁、榨汁儿\",\"opt_desc\":\"我都不会！\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/C49DFE5C85EC4431A419A4B1135D9BCB.jpg\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"和面机\",\"opt_title\":\"九阳和面机\",\"opt_desc\":\"拉面，版面，你想吃啥？\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/F7AC9DCC9E5B47308D37E276CAF21D81.jpg\",\"block_opt\":{\"opt_type\":\"GOODS\",\"opt_value\":\"127\",\"opt_title\":\"美的洗碗机\",\"opt_desc\":\"朋友，缺个洗碗的吗？\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/29DA2B13E3B84CB18450320125E55C48.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/185D7033DF244C19B7E28005EEBA0276.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/69658873B466473E86037EF6174A3841.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/5E7130A6ED8E4A2E8FBF84564651E38F.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/48779A439E8E4E0AA838FFABCB6057C4.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/285274C3CCBE418C8585238071BC3C84.jpg\",\"block_opt\":{\"opt_type\":\"GOODS\",\"opt_value\":\"127\",\"opt_title\":\"空气净化器\",\"opt_desc\":\"清新空气，更清新你！\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/3FBAB8D9BA8C46D9AC458831FD3474B3.jpg\",\"block_opt\":{\"opt_type\":\"GOODS\",\"opt_value\":\"127\",\"opt_title\":\"清凉一夏\",\"opt_desc\":\"死肥宅，买台空调吧！\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/4099B8327079497380E92EABCA481D9A.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/DAFEFD6598034ED598057242731F563F.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/95680D2AA6EF492D945A85FF0EBF2898.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}}]}]},{\"tpl_id\":2,\"tpl_type\":\"ADV\",\"columnList\":[{\"title\":\"旅行\",\"titleColors\":[\"#23C096\",\"#088865\"],\"tagList\":[{\"block_type\":\"TEXT\",\"block_value\":\"净化器\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"净化器\"}},{\"block_type\":\"TEXT\",\"block_value\":\"时尚名包\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"时尚名包\"}},{\"block_type\":\"TEXT\",\"block_value\":\"耳机\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"耳机\"}}],\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/E3EF313946EC4C5A973FE5C78510F71C.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/437E5DBE767A43C2BAF515BC66B562EE.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"星级酒店\",\"opt_desc\":\"低调奢华有内涵\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/880CAC023091410BA424D1D3C756F453.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"国际航班\",\"opt_desc\":\"全年飞行无忧\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/4381D16990E34CAC8750CEA78F0950E2.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"海航旅游\",\"opt_desc\":\"度假最好选择\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/BA9ADE64604B4CCC911AD699B19A78FA.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"冬季专享\",\"opt_desc\":\"感受大自然的气息\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/DF473847897B45F4966AD3CA1DEA8DF9.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/1C5028F888DC412687267D7F4DEAB6C6.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/842780724F8D40BBB0C870576DE9B9C6.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}}]},{\"title\":\"生活\",\"titleColors\":[\"#E6C633\",\"#877213\"],\"tagList\":[{\"block_type\":\"TEXT\",\"block_value\":\"净化器\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"空气净化器\"}},{\"block_type\":\"TEXT\",\"block_value\":\"名包\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"时尚名包\"}},{\"block_type\":\"TEXT\",\"block_value\":\"耳机\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"蓝牙耳机\"}}],\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/7D3F4DC517E84AE3AD33C17DFF75AE21.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/E5576641C63A4C72943A915FD8CE8FC9.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"高端美味\",\"opt_desc\":\"双人自助限时抢\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/BE3BEF4D09B64521B2F74A82FE799BB3.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"浪漫时光\",\"opt_desc\":\"展现最美的你\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/DB478845E0D84B17B6044E5A93FB5B09.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"唱响中国\",\"opt_desc\":\"经典好声音\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/966F8D117B3A4D299614D852475C0B8A.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"专业洗车\",\"opt_desc\":\"满10次送保养\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/6138B88665FE4DCFBF27C582CE30AB4E.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/25C6B9A457B54453A7F6B253ACAE20D9.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/E5F520F7ABFC4E6BA82B6B5786A0FDAF.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}}]}]},{\"tpl_id\":2,\"tpl_type\":\"ADV\",\"columnList\":[{\"title\":\"服装鞋帽\",\"titleColors\":[\"#B8846F\",\"#A41612\"],\"tagList\":[{\"block_type\":\"TEXT\",\"block_value\":\"连衣裙\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"连衣裙\"}},{\"block_type\":\"TEXT\",\"block_value\":\"鞋包\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"鞋包\"}},{\"block_type\":\"TEXT\",\"block_value\":\"时尚手表\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"时尚手表\"}},{\"block_type\":\"TEXT\",\"block_value\":\"运动户外\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"运动户外\"}},{\"block_type\":\"TEXT\",\"block_value\":\"太阳镜\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"太阳镜\"}}],\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/6A57945F4AB946F2B7177CF299583B4F.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/2AA8030D8B48401BA77E28BD55ACACE7.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"男装臻选\",\"opt_desc\":\"夏季热卖\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/F4F7F3C5897249889F05DBA73939BF44.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"街头时尚\",\"opt_desc\":\"迷人一夏\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/33E7E3803AFC4360B0B07AD39EB843C4.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"时尚辣妈\",\"opt_desc\":\"美孕佳人\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/2553922D92934D0D9F68E703D3672715.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"轻奢百搭\",\"opt_desc\":\"满1000减200\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/907904B9E4824F2E84193784D649847E.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/4699C9A8E2F346FA9341783334BFB029.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/897B6C997DE74931A21C24AFEDC9D3F3.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}}]},{\"title\":\"美妆个护\",\"titleColors\":[\"#7A747B\",\"#EB37D5\"],\"tagList\":[{\"block_type\":\"TEXT\",\"block_value\":\"防晒\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"防晒\"}},{\"block_type\":\"TEXT\",\"block_value\":\"口红\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"口红\"}},{\"block_type\":\"TEXT\",\"block_value\":\"魅力彩妆\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"魅力彩妆\"}},{\"block_type\":\"TEXT\",\"block_value\":\"洗护发\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"洗护发\"}},{\"block_type\":\"TEXT\",\"block_value\":\"面霜\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"面霜\"}}],\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/FF080CBC64B74F0E81EE62D899062CC6.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/2BCC29DE3BE44DDFAEC0C1104C37ED41.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"菲拉格慕\",\"opt_desc\":\"梦中情人\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/02DF31B100A547819653952CF87B91C7.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"超然无暇\",\"opt_desc\":\"自然色\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/A1DB0DF1B6A94936B86622F1F4967776.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"杰威尔男士\",\"opt_desc\":\"劲能焕白\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/455BAA30CA4A4CE080C5DC6058BD27DF.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"美宝莲定制\",\"opt_desc\":\"柔雾粉底液\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/83521C186D3F4783B3FBAE6694EE46D1.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/B0811D6B8C8E4765A76B426ABBFB63C9.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/58079FD5E799440A970703C2B8FE105E.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}}]}]},{\"tpl_id\":1,\"tpl_type\":\"ADV\",\"columnList\":[{\"title\":\"电脑数码\",\"titleColors\":[\"#333377\",\"#488bad\"],\"tagList\":[{\"block_type\":\"TEXT\",\"block_value\":\"笔记本\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"笔记本\"}},{\"block_type\":\"TEXT\",\"block_value\":\"电竞专用\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"电竞专用\"}},{\"block_type\":\"TEXT\",\"block_value\":\"二合一平板\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"二合一平板\"}},{\"block_type\":\"TEXT\",\"block_value\":\"时尚影音\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"时尚影音\"}},{\"block_type\":\"TEXT\",\"block_value\":\"娱乐先锋\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"娱乐先锋\"}},{\"block_type\":\"TEXT\",\"block_value\":\"摄影器械\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"摄影器械\"}}],\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/14FBA0A686FB4CE5871682D15C5810B2.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/8796A539D7FA4D66A02DA51BA8E3B0A0.png\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"女神专属\",\"opt_desc\":\"甜蜜小“新”机\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/2B730C4FB61A41DCAEAD69C1A9F6C62C.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"数码外设\",\"opt_desc\":\"新品上市\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/2900EA9160A84BDBAA8C496FBBB7083F.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"电脑配件\",\"opt_desc\":\"IPS广色域显示器\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/E07361AF6BF441ECBE89B5A92D26157B.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"自动办公\",\"opt_desc\":\"智能微投\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/0F6D2208CEC0410D93CCB2A9F8948502.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/BE535946BD504BEA87523294DD2222DD.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/0847CE2CEB7E4FFEBEFDD291A13D21E6.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/F5DF8EB3874E446A91F70DCDB30075A1.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/B74E7111EB5E45B9A35AACEE69866CCB.gif\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/546D9FFAF98A47CFBA3DA372F5CD318A.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"3D鼠标\",\"opt_desc\":\"更轻松更高效\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/70CACDC911BF4E559612F668B8A26227.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"美加狮\",\"opt_desc\":\"游戏手柄\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/75E93760051F4A4B86A619D5CDCB89B5.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/159E3E13AD204A279F000BB373C9928B.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/CD481480DD8C413EBF2E102181063412.png\",\"block_opt\":{\"opt_type\":\"NONE\"}}]}]},{\"tpl_id\":3,\"tpl_type\":\"ADV\",\"columnList\":[{\"title\":\"3C产品\",\"titleColors\":[\"#3aaba9\",\"#299b9a\"],\"tagList\":[{\"block_type\":\"TEXT\",\"block_value\":\"手机\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"手机\"}},{\"block_type\":\"TEXT\",\"block_value\":\"数码\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"数码\"}},{\"block_type\":\"TEXT\",\"block_value\":\"平板电脑\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"平板电脑\"}}],\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/2CBA43470D78462A903E53731252798F.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/231C9E5FC1CB4E8CBBC28B66CCFC81F8.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"3C新品\",\"opt_desc\":\"爆品推荐新品抢先\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/6DE99795D63340DF841AB28A8891E152.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"平板电脑\",\"opt_desc\":\"千元好机推荐\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/F40BBBCB031E4D17AD4187DF6F94E350.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/07C268AF701B46E8A22DC16E9DFE45A9.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}}]},{\"title\":\"运动户外\",\"titleColors\":[\"#568e7d\",\"#447e6c\"],\"tagList\":[{\"block_type\":\"TEXT\",\"block_value\":\"跑步鞋\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"跑步鞋\"}},{\"block_type\":\"TEXT\",\"block_value\":\"运动\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"运动\"}}],\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/AE786A8DC6764728BA8E4CC5043FDE3F.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/17AC63E700374E5C89532AB205799869.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"卫衣\",\"opt_desc\":\"带帽防风保暖\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/77BDA9F12DDF45D6924C136D76FB559C.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"户外\",\"opt_desc\":\"雷鹏徒步旅行者\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/E9300FDC45294BC68E9F601F79CCADEB.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/0ACCB5B9B8734B26B6CD4008441874F3.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}}]},{\"title\":\"汽车配套\",\"titleColors\":[\"#5a7259\",\"#425f41\"],\"tagList\":[{\"block_type\":\"TEXT\",\"block_value\":\"车载\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"车载\"}},{\"block_type\":\"TEXT\",\"block_value\":\"贴膜\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"贴膜\"}},{\"block_type\":\"TEXT\",\"block_value\":\"儿童座椅\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"儿童座椅\"}}],\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/B6379963240041A9ADAC8F6EA319C875.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/4968DAF7F0D8479B80EB87BF0858AA6E.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"车载电器\",\"opt_desc\":\"智能行车\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/9BD242B811F04F3B86E7ECB3D23FAD43.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"行车记录\",\"opt_desc\":\"1080P高清夜视\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/6167A20713A84BDAAE031BD094ADF3E9.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/91A0BAA04E494D15AC5BD4FDA6A84DDB.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}}]}]},{\"tpl_id\":1,\"tpl_type\":\"ADV\",\"columnList\":[{\"title\":\"食品生鲜\",\"titleColors\":[\"#E6ED64\",\"#A99C16\"],\"tagList\":[{\"block_type\":\"TEXT\",\"block_value\":\"中外名酒\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"中外名酒\"}},{\"block_type\":\"TEXT\",\"block_value\":\"休闲零食\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"休闲零食\"}},{\"block_type\":\"TEXT\",\"block_value\":\"三只松鼠\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"三只松鼠\"}},{\"block_type\":\"TEXT\",\"block_value\":\"进口食品\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"进口食品\"}},{\"block_type\":\"TEXT\",\"block_value\":\"冰冻冷鲜\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"冰冻冷鲜\"}},{\"block_type\":\"TEXT\",\"block_value\":\"烧烤食材\",\"block_opt\":{\"opt_type\":\"KEYWORD\",\"opt_value\":\"烧烤食材\"}}],\"blockList\":[{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/8F6AFEBCA5EE4D47BFC44556D405E588.png\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/010B50AED5054153B6FD68933A1268D3.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"七夕礼物\",\"opt_desc\":\"巧克力礼盒\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/51F16B8D09B645DF94CCE5E3534B543D.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"三只松鼠\",\"opt_desc\":\"手撕面包\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/16B41DC9E5A341D6AA5B4B9645BD8394.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"北冰洋\",\"opt_desc\":\"四合一套装\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/C19FDA4E05A6467DB6AC3C491F0C7989.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"蒙牛纯甄\",\"opt_desc\":\"礼盒装\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/CCDC71EF20AF424D8F4AEBBA91C8BE5F.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/E5778C1272EC4CEE8145E6B0BE757B47.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/222D02C3B01E47EC95511B670AF80283.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/011DD170323B4663B8274081EB70743F.png\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/3A6F69CF8C9941F7AD2D44843965857C.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/E4C3C9BA898D42D2BFEC5C3B055FA431.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"宁安堡\",\"opt_desc\":\"特优级枸杞\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/E51283AF4E7646CA839416B214A42A62.jpg\",\"block_opt\":{\"opt_type\":\"NONE\",\"opt_title\":\"谷怡斋\",\"opt_desc\":\"墨江紫米\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/A546BD6759A54E4FBAD5DABE663053B1.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/F9F08D8EB4CA491C8DFDABDE9D79F4BE.jpg\",\"block_opt\":{\"opt_type\":\"NONE\"}},{\"block_type\":\"IMAGE\",\"block_value\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/90BEE0817D2D4332938522A206046AB0.png\",\"block_opt\":{\"opt_type\":\"NONE\"}}]}]}]', 'INDEX', 'PC');

-- ----------------------------
-- Table structure for `es_receipt_content`
-- ----------------------------
DROP TABLE IF EXISTS `es_receipt_content`;
CREATE TABLE `es_receipt_content` (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '发票内容id',
  `content` varchar(255) DEFAULT NULL COMMENT '发票内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='发票内容(es_receipt_content)';

-- ----------------------------
-- Records of es_receipt_content
-- ----------------------------
INSERT INTO `es_receipt_content` VALUES ('1', '办公用品');
INSERT INTO `es_receipt_content` VALUES ('2', '劳保用品');
INSERT INTO `es_receipt_content` VALUES ('3', '耗材');


-- ----------------------------
-- Table structure for `es_role`
-- ----------------------------
DROP TABLE IF EXISTS `es_role`;
CREATE TABLE `es_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `role_name` varchar(255) DEFAULT NULL COMMENT '角色名称',
  `auth_ids` longtext COMMENT '角色介绍',
  `role_describe` varchar(255) DEFAULT NULL COMMENT '角色描述',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='角色表(es_role)';

-- ----------------------------
-- Records of es_role
-- ----------------------------
INSERT INTO `es_role` VALUES ('21', '超级管理员', '[{\"title\":\"商品管理\",\"identifier\":\"goods\",\"checked\":true,\"authRegular\":\"/goods.*\",\"children\":[{\"title\":\"商品列表\",\"identifier\":\"goodsList\",\"checked\":true,\"authRegular\":\"/admin/goods.*\",\"children\":[]},{\"title\":\"商品设置\",\"identifier\":\"goodsSetting\",\"checked\":true,\"authRegular\":\"/goodsSetting.*\",\"children\":[{\"title\":\"分类列表\",\"identifier\":\"categoryList\",\"checked\":true,\"authRegular\":\"(/admin/goods/categories.*)|(/admin/goods/parameters.*)|(/admin/goods/parameter-groups.*)\",\"children\":[]},{\"title\":\"品牌列表\",\"identifier\":\"brandList\",\"checked\":true,\"authRegular\":\"/admin/goods/brands.*\",\"children\":[]},{\"title\":\"规格列表\",\"identifier\":\"specList\",\"checked\":true,\"authRegular\":\"/admin/goods/specs.*\",\"children\":[]}]},{\"title\":\"商品审核\",\"identifier\":\"goodsAudit\",\"checked\":true,\"authRegular\":\"/admin/goods.*\",\"children\":[]}]},{\"title\":\"订单管理\",\"identifier\":\"order\",\"checked\":true,\"authRegular\":\"/order.*\",\"children\":[{\"title\":\"订单列表\",\"identifier\":\"orderList\",\"checked\":true,\"authRegular\":\"(/admin/trade/orders.*)|(/admin/shops.*)\",\"children\":[]},{\"title\":\"退款单\",\"identifier\":\"refundList\",\"checked\":true,\"authRegular\":\"(/admin/after-sales/refund.*)|(/admin/after-sales/exports.*)\",\"children\":[]},{\"title\":\"收款单\",\"identifier\":\"collectionList\",\"checked\":true,\"authRegular\":\"/admin/trade/orders/pay-log.*\",\"children\":[]},{\"title\":\"开票历史\",\"identifier\":\"receiptHistory\",\"checked\":true,\"authRegular\":\"/admin/members/receipts.*\",\"children\":[]}]},{\"title\":\"会员管理\",\"identifier\":\"member\",\"checked\":true,\"authRegular\":\"/member.*\",\"children\":[{\"title\":\"管理会员\",\"identifier\":\"memberManage\",\"checked\":true,\"authRegular\":\"/member.*\",\"children\":[{\"title\":\"会员列表\",\"identifier\":\"memberList\",\"checked\":true,\"authRegular\":\"(/admin/members.*)|(/admin/trade/orders.*)\",\"children\":[]},{\"title\":\"会员回收站\",\"identifier\":\"memberRecycle\",\"checked\":true,\"authRegular\":\"/admin/members.*\",\"children\":[]}]},{\"title\":\"商品评论\",\"identifier\":\"goodsComment\",\"checked\":true,\"authRegular\":\"/member.*\",\"children\":[{\"title\":\"商品评论列表\",\"identifier\":\"mgoodsCommentList\",\"checked\":true,\"authRegular\":\"/admin/members/comments.*\",\"children\":[]},{\"title\":\"商品咨询列表\",\"identifier\":\"goodsAskList\",\"checked\":true,\"authRegular\":\"/admin/members/asks.*\",\"children\":[]}]},{\"title\":\"站内消息\",\"identifier\":\"memberNotification\",\"checked\":true,\"authRegular\":\"/admin/systems/messages.*\",\"children\":[{\"title\":\"站内消息\",\"identifier\":\"notificationHistory\",\"checked\":true,\"authRegular\":\"/admin/systems/messages.*\",\"children\":[]}]}]},{\"title\":\"店铺管理\",\"identifier\":\"shop\",\"checked\":true,\"authRegular\":\"/shop.*\",\"children\":[{\"title\":\"管理店铺\",\"identifier\":\"shopManage\",\"checked\":true,\"authRegular\":\"/shop,*\",\"children\":[{\"title\":\"店铺列表\",\"identifier\":\"shopList\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/goods/categories.*)\",\"children\":[]},{\"title\":\"店铺审核\",\"identifier\":\"shopAudit\",\"checked\":true,\"authRegular\":\"/admin/shops.*\",\"children\":[]}]},{\"title\":\"店铺模板管理\",\"identifier\":\"shopThemeManage\",\"checked\":true,\"authRegular\":\"/shop.*\",\"children\":[{\"title\":\"模板列表\",\"identifier\":\"themeList\",\"checked\":true,\"authRegular\":\"/admin/shops/themes.*\",\"children\":[]},{\"title\":\"WAP模板列表\",\"identifier\":\"themeListWap\",\"checked\":true,\"authRegular\":\"/admin/shops/themes.*\",\"children\":[]}]},{\"title\":\"结算管理\",\"identifier\":\"settlementManage\",\"checked\":true,\"authRegular\":\"/admin/order/bills.*\",\"children\":[{\"title\":\"结算周期\",\"identifier\":\"settlement\",\"checked\":true,\"authRegular\":\"/admin/order/bills.*\",\"children\":[]}]}]},{\"title\":\"促销管理\",\"identifier\":\"promotions\",\"checked\":true,\"authRegular\":\"/admin/promotions.*\",\"children\":[{\"title\":\"团购管理\",\"identifier\":\"groupBuyManage\",\"checked\":true,\"authRegular\":\"/promotion.*\",\"children\":[{\"title\":\"团购列表\",\"identifier\":\"groupBuyList\",\"checked\":true,\"authRegular\":\"/admin/promotion.*\",\"children\":[]},{\"title\":\"团购分类\",\"identifier\":\"groupBuyCategory\",\"checked\":true,\"authRegular\":\"/admin/promotion/group-buy-cats.*\",\"children\":[]}]},{\"title\":\"积分商城\",\"identifier\":\"pointsMallManage\",\"checked\":true,\"authRegular\":\"/promotion.*\",\"children\":[{\"title\":\"积分分类\",\"identifier\":\"pointsClassify\",\"checked\":true,\"authRegular\":\"/admin/promotion/exchange-cats.*\",\"children\":[]},{\"title\":\"积分商品\",\"identifier\":\"pointsGoods\",\"checked\":true,\"authRegular\":\"/admin/goods.*\",\"children\":[]}]},{\"title\":\"限时抢购\",\"identifier\":\"seckillManage\",\"checked\":true,\"authRegular\":\"/admin/promotion.*\",\"children\":[{\"title\":\"限时抢购\",\"identifier\":\"seckillList\",\"checked\":true,\"authRegular\":\"/admin/promotion.*\",\"children\":[]}]}]},{\"title\":\"页面设置\",\"identifier\":\"page\",\"checked\":true,\"authRegular\":\"/page.*\",\"children\":[{\"title\":\"PC装修\",\"identifier\":\"pcDecoration\",\"checked\":true,\"authRegular\":\"/page.*\",\"children\":[{\"title\":\"楼层装修\",\"identifier\":\"pcFloorManage\",\"checked\":true,\"authRegular\":\"/admin/pages.*\",\"children\":[]},{\"title\":\"焦点图管理\",\"identifier\":\"pcFocusManage\",\"checked\":true,\"authRegular\":\"/admin/focus-pictures.*\",\"children\":[]}]},{\"title\":\"移动端装修\",\"identifier\":\"mobileDecoration\",\"checked\":true,\"authRegular\":\"/page.*\",\"children\":[{\"title\":\"楼层装修\",\"identifier\":\"mobileFloorManage\",\"checked\":true,\"authRegular\":\"/admin/pages.*\",\"children\":[]},{\"title\":\"焦点图管理\",\"identifier\":\"mobileFocusManage\",\"checked\":true,\"authRegular\":\"/admin/focus-pictures.*\",\"children\":[]}]},{\"title\":\"页面设置\",\"identifier\":\"pageSetting\",\"checked\":true,\"authRegular\":\"/page.*\",\"children\":[{\"title\":\"PC导航菜单\",\"identifier\":\"pcSiteMenu\",\"checked\":true,\"authRegular\":\"/admin/pages/site-navigations.*\",\"children\":[]},{\"title\":\"移动端导航菜单\",\"identifier\":\"mobileSiteMenu\",\"checked\":true,\"authRegular\":\"/admin/pages/site-navigations.*\",\"children\":[]},{\"title\":\"热门关键字\",\"identifier\":\"hotKeyword\",\"checked\":true,\"authRegular\":\"/admin/pages/hot-keywords.*\",\"children\":[]}]}]},{\"title\":\"统计分析\",\"identifier\":\"statistics\",\"checked\":true,\"authRegular\":\"/statistics.*\",\"children\":[{\"title\":\"会员分析\",\"identifier\":\"memberAnalysis\",\"checked\":true,\"authRegular\":\"/statistics.*\",\"children\":[{\"title\":\"会员下单量\",\"identifier\":\"orderAmount\",\"checked\":true,\"authRegular\":\"/admin/statistics.*\",\"children\":[]},{\"title\":\"新增会员统计\",\"identifier\":\"addedMember\",\"checked\":true,\"authRegular\":\"/admin/statistics.*\",\"children\":[]}]},{\"title\":\"商品统计\",\"identifier\":\"goodsStatistics\",\"checked\":true,\"authRegular\":\"/statistic.*\",\"children\":[{\"title\":\"价格销量\",\"identifier\":\"priceSales\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/goods.*)|(/admin/statistics.*)\",\"children\":[]},{\"title\":\"热卖商品统计\",\"identifier\":\"hotGoods\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/goods.*)|(/admin/statistics.*)\",\"children\":[]},{\"title\":\"商品销售明细\",\"identifier\":\"goodsSalesDetails\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/goods.*)|(/admin/statistics.*)\",\"children\":[]},{\"title\":\"商品收藏统计\",\"identifier\":\"goodsCollect\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/goods.*)|(/admin/statistics.*)\",\"children\":[]}]},{\"title\":\"行业分析\",\"identifier\":\"industryAnalysis\",\"checked\":true,\"authRegular\":\"/statistic.*\",\"children\":[{\"title\":\"行业规模\",\"identifier\":\"industryScale\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/statistics.*)\",\"children\":[]},{\"title\":\"概括总览\",\"identifier\":\"generalityOverview\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/statistics.*)\",\"children\":[]}]},{\"title\":\"流量分析\",\"identifier\":\"trafficAnalysis\",\"checked\":true,\"authRegular\":\"/admin/statistics.*\",\"children\":[{\"title\":\"店铺流量分析\",\"identifier\":\"trafficAnalysisShop\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/statistics.*)\",\"children\":[]},{\"title\":\"商品流量分析\",\"identifier\":\"trafficAnalysisGoods\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/statistics.*)\",\"children\":[]}]},{\"title\":\"其它统计\",\"identifier\":\"otherStatistics\",\"checked\":true,\"authRegular\":\"/statistics.*\",\"children\":[{\"title\":\"订单统计\",\"identifier\":\"orderStatistics\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/statistics.*)\",\"children\":[]},{\"title\":\"销售收入统计\",\"identifier\":\"salesRevenueStatistics\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/statistics.*)\",\"children\":[]},{\"title\":\"区域分析\",\"identifier\":\"regionalAnalysis\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/statistics.*)\",\"children\":[]},{\"title\":\"客单价分布图\",\"identifier\":\"customerPriceDistribution\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/goods/categories.*)|(/admin/statistics.*)\",\"children\":[]},{\"title\":\"退款统计\",\"identifier\":\"refundStatistics\",\"checked\":true,\"authRegular\":\"(/admin/shops.*)|(/admin/statistics/order/return.*)\",\"children\":[]}]}]},{\"title\":\"设置管理\",\"identifier\":\"setting\",\"checked\":true,\"authRegular\":\"/system.*\",\"children\":[{\"title\":\"网店设置\",\"identifier\":\"shopSettings\",\"checked\":true,\"authRegular\":\"/system.*\",\"children\":[{\"title\":\"系统设置\",\"identifier\":\"systemSettings\",\"checked\":true,\"authRegular\":\"(/admin/settings.*)|(/admin/goods.*)|(/admin/trade.*)\",\"children\":[]},{\"title\":\"SMTP设置\",\"identifier\":\"smtpSettings\",\"checked\":false,\"authRegular\":\"/admin/systems/smtps.*\",\"children\":[]},{\"title\":\"短信网关设置\",\"identifier\":\"smsGatewaySettings\",\"checked\":false,\"authRegular\":\"/admin/systems/platforms.*\",\"children\":[]},{\"title\":\"快递平台设置\",\"identifier\":\"expressPlatformSettings\",\"checked\":false,\"authRegular\":\"/admin/systems/express-platforms.*\",\"children\":[]},{\"title\":\"电子面单\",\"identifier\":\"electronicrEceipt\",\"checked\":false,\"authRegular\":\"/admin/systems/waybills.*\",\"children\":[]},{\"title\":\"储存方案\",\"identifier\":\"storageSolution\",\"checked\":false,\"authRegular\":\"/admin/systems/uploaders.*\",\"children\":[]},{\"title\":\"静态页\",\"identifier\":\"staticPage\",\"checked\":true,\"authRegular\":\"(/admin/task.*)|(/admin/page-create.*)\",\"children\":[]},{\"title\":\"商品索引\",\"identifier\":\"goodsIndex\",\"checked\":true,\"authRegular\":\"(/admin/task.*)|(/admin/goods/search.*)\",\"children\":[]},{\"title\":\"信任登录\",\"identifier\":\"trustLogin\",\"checked\":false,\"authRegular\":\"/admin/members/connect.*\",\"children\":[]}]},{\"title\":\"消息设置\",\"identifier\":\"messageSettings\",\"checked\":true,\"authRegular\":\"/system.*\",\"children\":[{\"title\":\"店铺消息\",\"identifier\":\"shopMessageSettings\",\"checked\":true,\"authRegular\":\"/admin/systems/message-templates.*\",\"children\":[]},{\"title\":\"会员消息\",\"identifier\":\"memberMessageSettings\",\"checked\":true,\"authRegular\":\"/admin/systems/message-templates.*\",\"children\":[]}]},{\"title\":\"推送设置\",\"identifier\":\"pushSettings\",\"checked\":true,\"authRegular\":\"/admin/systems.*\",\"children\":[{\"title\":\"商品推送\",\"identifier\":\"goodsPush\",\"checked\":true,\"authRegular\":\"/admin/systems.*\",\"children\":[]},{\"title\":\"APP推送\",\"identifier\":\"appPush\",\"checked\":true,\"authRegular\":\"/admin/systems.*\",\"children\":[]}]},{\"title\":\"支付和配送\",\"identifier\":\"paymentAndDelivery\",\"checked\":true,\"authRegular\":\"/system.*\",\"children\":[{\"title\":\"支付方式\",\"identifier\":\"paymentSettings\",\"checked\":true,\"authRegular\":\"(/base-api/uploaders.*)|(/admin/payment/payment-methods.*)\",\"children\":[]},{\"title\":\"物流公司\",\"identifier\":\"expressSettings\",\"checked\":true,\"authRegular\":\"/admin/systems/logi-companies.*\",\"children\":[]},{\"title\":\"区域管理\",\"identifier\":\"regionalManagementSettings\",\"checked\":true,\"authRegular\":\"/base-api/regions.*\",\"children\":[]}]},{\"title\":\"权限管理\",\"identifier\":\"authSettings\",\"checked\":false,\"authRegular\":\"/system.*\",\"children\":[{\"title\":\"管理员管理\",\"identifier\":\"administratorManage\",\"checked\":false,\"authRegular\":\"(/base-api/uploaders.*)|(/admin/systems/manager/admin-users.*)\",\"children\":[]},{\"title\":\"角色管理\",\"identifier\":\"roleManage\",\"checked\":false,\"authRegular\":\"(/admin/systems/roles.*)|(/admin/systems/menus.*)\",\"children\":[]}]}]},{\"title\":\"开发管理\",\"identifier\":\"development\",\"checked\":true,\"authRegular\":\"/development.*\",\"children\":[{\"title\":\"菜单管理\",\"identifier\":\"toolManage\",\"checked\":false,\"authRegular\":\"/admin/systems/menus.*\",\"children\":[{\"title\":\"菜单管理\",\"identifier\":\"menuManage\",\"checked\":false,\"authRegular\":\"/admin/systems/menus.*\",\"children\":[]}]},{\"title\":\"文章管理\",\"identifier\":\"articleManage\",\"checked\":true,\"authRegular\":\"/system.*\",\"children\":[{\"title\":\"文章列表\",\"identifier\":\"articleList\",\"checked\":true,\"authRegular\":\"(/admin/systems/admin-users.*)|(/admin/pages.*)\",\"children\":[]},{\"title\":\"文章分类\",\"identifier\":\"articleCategory\",\"checked\":true,\"authRegular\":\"/admin/pages/article-categories.*\",\"children\":[]}]}]},{\"title\":\"分销管理\",\"identifier\":\"distribution\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[{\"title\":\"提成模板\",\"identifier\":\"extractTpl\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[{\"title\":\"个人提成模板\",\"identifier\":\"perAccomplishmentTpl\",\"checked\":true,\"authRegular\":\"/admin/distribution.*\",\"children\":[]},{\"title\":\"升级日志\",\"identifier\":\"upgradeLogs\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[]}]},{\"title\":\"分销商管理\",\"identifier\":\"distributor\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[{\"title\":\"个人分销商\",\"identifier\":\"distributorList\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[]},{\"title\":\"分销商统计\",\"identifier\":\"distributorStatistics\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[]}]},{\"title\":\"业绩管理\",\"identifier\":\"achievement\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[{\"title\":\"业绩列表\",\"identifier\":\"achievementList\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[]},{\"title\":\"账单列表\",\"identifier\":\"billList\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[]},{\"title\":\"结算单详情\",\"identifier\":\"billDetails\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[]}]},{\"title\":\"提现管理\",\"identifier\":\"putforwardManage\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[{\"title\":\"提现设置\",\"identifier\":\"putforwardSettings\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[]},{\"title\":\"提现申请\",\"identifier\":\"putforwardApply\",\"checked\":true,\"authRegular\":\"/distribution.*\",\"children\":[]}]}]}]', '超级管理员');

-- ----------------------------
-- Table structure for `es_sensitive_words`
-- ----------------------------
DROP TABLE IF EXISTS `es_sensitive_words`;
CREATE TABLE `es_sensitive_words` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `word_name` varchar(255) DEFAULT NULL COMMENT '敏感词名称',
  `create_time` bigint(20) DEFAULT NULL COMMENT '创建时间',
  `is_delete` smallint(1) DEFAULT NULL COMMENT '删除状态  1正常 0 删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='敏感词(es_sensitive_words)';

-- ----------------------------
-- Records of es_sensitive_words
-- ----------------------------

-- ----------------------------
-- Table structure for `es_settings`
-- ----------------------------
DROP TABLE IF EXISTS `es_settings`;
CREATE TABLE `es_settings` (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '系统设置id',
  `cfg_value` longtext COMMENT '系统配置信息',
  `cfg_group` varchar(255) DEFAULT NULL COMMENT '业务设置标识',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=489 DEFAULT CHARSET=utf8 COMMENT='系统设置(es_settings)';

-- ----------------------------
--  Records of `es_settings`
-- ----------------------------
BEGIN;
INSERT INTO `es_settings` VALUES ('2', '{\"marcket_auth\":1,\"update_auth\":1,\"comment_auth\":1,\"ask_auth\":1,\"thumbnail_width\":300,\"thumbnail_height\":300,\"small_width\":400,\"small_height\":400,\"big_width\":800,\"big_height\":800}', 'GOODS'), ('39', '{\"site_name\":\"Javashop多店铺示例商城\",\"title\":\"Javashop多店铺示例商城\",\"keywords\":\"最好的java网店系统,java多用户商城,java商城定制开发\",\"descript\":\"Javashop提供优质的电子商务解决方案，提供最好的Java网店系统、Java多用户商城、Java商城定制开发。\",\"siteon\":1,\"close_reson\":\"javashop\",\"logo\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/961A5B5359FF4DE9AF24E3B4F2CEB1E8.png\",\"global_auth_key\":\"aaaa\",\"default_img\":\"http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/F696BAFE27ED4C0F9081C5A3C6625507.png\",\"test_mode\":0}', 'SITE'), ('80', '{\"android_push_secret\":\"\",\"android_goods_activity\":\"\",\"android_push_key\":\"\",\"ios_push_secret\":\"eeee\",\"ios_push_key\":\"ddd\"}', 'PUSH'), ('330', '{\"cycle\":30,\"goods_model\":1}', 'DISTRIBUTION'), ('419', '{\"register\":0,\"register_consumer_point\":1,\"register_grade_point\":1,\"login\":1,\"login_consumer_point\":1,\"login_grade_point\":1,\"online_pay\":1,\"online_pay_consumer_point\":1,\"online_pay_grade_point\":1,\"comment_img\":1,\"comment_img_consumer_point\":1,\"comment_img_grade_point\":1,\"comment\":1,\"comment_consumer_point\":1,\"comment_grade_point\":1,\"first_comment\":1,\"first_comment_consumer_point\":10,\"first_comment_grade_point\":10,\"buy_goods\":1,\"buy_goods_consumer_point\":1,\"buy_goods_grade_point\":1,\"parities\":1,\"parities_point\":1}', 'POINT'), ('486', '{\"cancel_order_day\":1,\"rog_order_day\":1,\"comment_order_day\":1,\"service_expired_day\":1,\"complete_order_day\":3,\"complete_order_pay\":1,\"complain_expired_day\":30}', 'TRADE'), ('487', '{\"static_page_address\":\"http://192.168.2.4:3000\",\"static_page_wap_address\":\"http://192.168.2.4:3001\"}', 'PAGE'), ('488', '{\"password\":\"222\",\"secret_key\":\"222\"}', 'ES_SIGN');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
-- ----------------------------
-- Table structure for `es_site_navigation`
-- ----------------------------
DROP TABLE IF EXISTS `es_site_navigation`;
CREATE TABLE `es_site_navigation` (
  `navigation_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `navigation_name` varchar(100) DEFAULT NULL COMMENT '导航名称',
  `url` varchar(255) DEFAULT NULL COMMENT '导航地址',
  `client_type` varchar(50) DEFAULT NULL COMMENT '客户端类型',
  `image` longtext COMMENT '图片',
  `sort` int(5) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`navigation_id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COMMENT='导航栏(es_site_navigation)';

-- ----------------------------
-- Records of es_site_navigation
-- ----------------------------
INSERT INTO `es_site_navigation` VALUES ('22', '限时抢购', '/seckill', 'PC', '', '1');
INSERT INTO `es_site_navigation` VALUES ('23', '积分商城', '/points-mall', 'PC', '', '2');
INSERT INTO `es_site_navigation` VALUES ('24', '团购商城', '/group-buy', 'PC', '', '3');
INSERT INTO `es_site_navigation` VALUES ('25', '数码家电', '/goods?keyword=数码家电', 'PC', '', '4');
INSERT INTO `es_site_navigation` VALUES ('26', '女装', '/goods?keyword=女装', 'PC', '', '5');
INSERT INTO `es_site_navigation` VALUES ('27', '男装', '/goods?keyword=男装', 'PC', '', '6');
INSERT INTO `es_site_navigation` VALUES ('28', '美容化妆', '/goods?keyword=美容化妆', 'PC', '', '7');
INSERT INTO `es_site_navigation` VALUES ('50', '本地超市', '/goods/127', 'MOBILE', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/229BD074244C4C76A512979C91E60AAE.png', '8');
INSERT INTO `es_site_navigation` VALUES ('51', '唯品会', '/goods/127', 'MOBILE', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/ABF90A19C26E468487A6DA545BEC6DD3.png', '9');
INSERT INTO `es_site_navigation` VALUES ('52', '本地服饰', '/goods/127', 'MOBILE', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/A70BA5102022476AB22548980499B19D.png', '10');
INSERT INTO `es_site_navigation` VALUES ('53', '本地生鲜', '/goods/127', 'MOBILE', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/6EE3100AB84748C0BEF04844A7497DDD.png', '11');
INSERT INTO `es_site_navigation` VALUES ('54', '排行榜', '/goods/127', 'MOBILE', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/5863D46DB1434D569D99D29FC4C42C0E.png', '12');
INSERT INTO `es_site_navigation` VALUES ('55', '充值缴费', '/goods/127', 'MOBILE', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/77A29A2D98164A108541F867A620E566.png', '13');
INSERT INTO `es_site_navigation` VALUES ('56', '拼团秒杀', '/assemble', 'MOBILE', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/F1FAF10D70664D3089D14B13B587A08F.png', '14');
INSERT INTO `es_site_navigation` VALUES ('57', '领券', '/coupons', 'MOBILE', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/DCBD3B78A698461BAE06F53D1CCC6D46.png', '15');
INSERT INTO `es_site_navigation` VALUES ('58', '赚钱', '/goods/127', 'MOBILE', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/508E674132224F22BFE360D3A4C30E77.png', '16');
INSERT INTO `es_site_navigation` VALUES ('59', '积分商城', '/points-mall', 'MOBILE', 'http://javashop-statics.oss-cn-beijing.aliyuncs.com/v70/null/D7FF82F35D024195A90E24AD4783B415.png', '17');
INSERT INTO `es_site_navigation` VALUES ('60', '领券', '/coupons', 'PC', '', '18');

-- ----------------------------
-- Table structure for `es_sms_platform`
-- ----------------------------
DROP TABLE IF EXISTS `es_sms_platform`;
CREATE TABLE `es_sms_platform` (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(50) DEFAULT NULL COMMENT '平台名称',
  `open` int(8) DEFAULT NULL COMMENT '是否开启',
  `config` longtext COMMENT '配置',
  `bean` varchar(50) DEFAULT NULL COMMENT 'beanid',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='短信网关(es_sms_platform)';

-- ----------------------------
-- Records of es_sms_platform
-- ----------------------------
INSERT INTO `es_sms_platform` VALUES ('15', '助通网关短信', '1', '[{\"name\":\"name\",\"text\":\"用户名\",\"type\":\"text\",\"value\":\"输入输入用户名\"},{\"name\":\"password\",\"text\":\"密码\",\"type\":\"text\",\"value\":\"输入输入密码\"},{\"name\":\"id\",\"text\":\"产品id\",\"type\":\"text\",\"value\":\"输入产品id\"},{\"name\":\"trumpet\",\"text\":\"扩展的小号（没有请留空）\",\"type\":\"text\",\"value\":\"\"}]', 'smsZtPlugin');

-- ----------------------------
-- Table structure for `es_smtp`
-- ----------------------------
DROP TABLE IF EXISTS `es_smtp`;
CREATE TABLE `es_smtp` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `host` varchar(50) DEFAULT NULL COMMENT '主机',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `last_send_time` bigint(20) DEFAULT NULL COMMENT '最后发信时间',
  `send_count` int(11) DEFAULT '0' COMMENT '已发数',
  `max_count` int(11) DEFAULT NULL COMMENT '最大发信数',
  `mail_from` varchar(255) DEFAULT NULL COMMENT '发信邮箱',
  `port` int(10) DEFAULT '0' COMMENT '端口',
  `open_ssl` int(1) DEFAULT '0' COMMENT 'ssl是否开启',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='邮件(es_smtp)';

-- ----------------------------
-- Records of es_smtp
-- ----------------------------
INSERT INTO `es_smtp` VALUES ('2', '请输入SMTP HOST参数', '请输入用户名', 'Abc123456', '0', '0', '100', '请输入发件箱', '456', '1');

-- ----------------------------
-- Table structure for `es_uploader`
-- ----------------------------
DROP TABLE IF EXISTS `es_uploader`;
CREATE TABLE `es_uploader` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '储存id',
  `name` varchar(50) DEFAULT NULL COMMENT '存储名称',
  `open` int(2) DEFAULT NULL COMMENT '是否开启',
  `config` longtext COMMENT '存储配置',
  `bean` varchar(50) DEFAULT NULL COMMENT '存储插件id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='存储方案(es_uploader)';

-- ----------------------------
-- Records of es_uploader
-- ----------------------------
INSERT INTO `es_uploader` VALUES ('1', 'oss', '1', '[{\"name\":\"endpoint\",\"text\":\"域名\",\"type\":\"text\",\"value\":\"输入阿里云OSS域名\"},{\"name\":\"bucketName\",\"text\":\"储存空间\",\"type\":\"text\",\"value\":\"输入阿里云OSS 存储空间\"},{\"name\":\"picLocation\",\"text\":\"二级路径\",\"type\":\"text\",\"value\":\"输入阿里云OSS 二级目录\"},{\"name\":\"accessKeyId\",\"text\":\"密钥id\",\"type\":\"text\",\"value\":\"输入阿里云OSS 密钥id\"},{\"name\":\"accessKeySecret\",\"text\":\"密钥\",\"type\":\"text\",\"value\":\"输入阿里云OSS 密钥\"}]', 'ossPlugin'), ('2', '本地存储', '0', '[{\"name\":\"nginx_open\",\"text\":\"nginx支持\",\"type\":\"radio\",\"options\":[{\"label\":\"不支持\",\"value\":0},{\"label\":\"支持\",\"value\":1}]},{\"name\":\"static_server_domain\",\"text\":\"域名\",\"type\":\"text\"},{\"name\":\"static_server_path\",\"text\":\"路径\",\"type\":\"text\"}]', 'localPlugin');

-- ----------------------------
-- Table structure for `es_waybill`
-- ----------------------------
DROP TABLE IF EXISTS `es_waybill`;
CREATE TABLE `es_waybill` (
  `id` int(8) NOT NULL AUTO_INCREMENT COMMENT '电子面单id',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `open` int(2) DEFAULT NULL COMMENT '是否开启',
  `config` longtext COMMENT '电子面单配置',
  `bean` varchar(50) DEFAULT NULL COMMENT 'beanid',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='电子面单(es_waybill)';

-- ----------------------------
-- Records of es_waybill
-- ----------------------------
INSERT INTO `es_waybill` VALUES ('25', '快递鸟', '1', '[{\"name\":\"EBusinessID\",\"text\":\"电商ID\",\"type\":\"text\",\"value\":\"输入电商id\"},{\"name\":\"AppKey\",\"text\":\"密钥\",\"type\":\"text\",\"value\":\"输入密钥\"},{\"name\":\"ReqURL\",\"text\":\"请求url\",\"type\":\"text\",\"value\":\"输入url\"}]', 'kdnPlugin');

-- ----------------------------
-- Table structure for `es_wechat_msg_template`
-- ----------------------------
DROP TABLE IF EXISTS `es_wechat_msg_template`;
CREATE TABLE `es_wechat_msg_template` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
`msg_tmp_name` varchar(50) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '模板名称',
`msg_tmp_sn` varchar(50) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '消息编号',
`template_id` varchar(100) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '模板ID',
`msg_first` varchar(255) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '消息开头文字',
`msg_remark` varchar(255) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '消息结尾备注文字',
`is_open` smallint(1) DEFAULT NULL COMMENT '是否开启',
`tmp_type` varchar(50) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '模板类型，枚举',
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
--  Table structure for `es_logistics_company`
-- ----------------------------
DROP TABLE IF EXISTS `es_logistics_company`;
CREATE TABLE `es_logistics_company` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `is_waybill` int(1) DEFAULT NULL,
  `kdcode` varchar(100) DEFAULT NULL,
  `form_items` varchar(255) DEFAULT NULL,
  `delete_status` varchar(255) DEFAULT 'NORMAL' COMMENT '是否删除 DELETED：已删除，NORMAL：正常',
  `disabled` varchar(255) DEFAULT NULL COMMENT '是否禁用 OPEN：开启，CLOSE：禁用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `es_logistics_company`
-- ----------------------------
INSERT INTO `es_logistics_company` VALUES ('1', '圆通速递', 'yuantong', '1', 'YTO', '[{\"name\":\"商家代码\",\"code\":\"customer_name\"},{\"name\":\"密钥串\",\"code\":\"month_code\"}]', 'NORMAL', 'OPEN');
INSERT INTO `es_logistics_company` VALUES ('8', '韵达快递', 'yunda', '1', 'YD', '[{\"name\":\"客户ID\",\"code\":\"customer_name\"},{\"name\":\"接口联调密码\",\"code\":\"customer_pwd\"}]', 'NORMAL', 'OPEN');
INSERT INTO `es_logistics_company` VALUES ('9', '顺丰物流', 'shunfeng', '1', 'SF', '[{\"name\":\"月结号\",\"code\":\"month_code\"}]', 'NORMAL', 'OPEN');
INSERT INTO `es_logistics_company` VALUES ('10', '申通快递', 'shentong', '1', 'ST', '[{\"name\":\"客户简称\",\"code\":\"customer_name\"},{\"name\":\"客户密码\",\"code\":\"customer_pwd\"},{\"name\":\"所属网点\",\"code\":\"send_site\"}]', 'NORMAL', 'OPEN');
INSERT INTO `es_logistics_company` VALUES ('11', '邮政', 'youzheng', '0', 'YZ', '[]', 'NORMAL', 'OPEN');
INSERT INTO `es_logistics_company` VALUES ('12', '中通', 'zhongtong', '1', 'ZT', '[{\"name\":\"商家ID\",\"code\":\"customer_name\"},{\"name\":\"商家接口密码\",\"code\":\"customer_pwd\"}]', 'NORMAL', 'OPEN');

-- ----------------------------
--  Table structure for `es_complain_topic`
-- ----------------------------
DROP TABLE IF EXISTS `es_complain_topic`;
CREATE TABLE `es_complain_topic` (
`topic_id` int(10) NOT NULL AUTO_INCREMENT COMMENT ' 主键',
`topic_name` varchar(50) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '投诉主题',
`create_time` bigint(20) DEFAULT NULL COMMENT '添加时间',
`topic_remark` varchar(100) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT '主题说明',
 PRIMARY KEY (`topic_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 如果已经按照文档更改了数据库字符集，请将下面注释的的脚本在相应的库中执行
-- alter table es_admin_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_article CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_article_category CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_email CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_express_platform CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_focus_picture CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_hot_keyword CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_logi_company CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_menu CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_message CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_message_template CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_page CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_receipt_content CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_regions CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_role CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sensitive_words CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_settings CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_site_navigation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_sms_platform CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_smtp CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_uploader CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_waybill CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- alter table es_logistics_company CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
